×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hi Darryl,
Two things come to mind:
First:
Look at the table SYSCOLUMNS. E.g.
Select length from syscolumns where system_column_name = 'column-name' and system_table_name = 'table_name'
Second:
Length(column-name) will return the length in bytes, which will work for you if the numeric field is zoned.
It will retrieve the length on the column for every record so you must use " Fetch First Row Only".
To get the maximum value, I think this would work: 10**length(column-name)-1
Something like this perhaps:
select 10**length(column-name)-1 from file-name
Fetch First Row Only
If your column is not zoned, I don't know.
I could be wrong but I seem to recall Birgitta writing about this a while back but I don't remember the specifics.
It might not be in the RPG list though since this is SQL.
Sorry I couldn't help more.
Yours truly,
Glenn Gundermann
Manager, IT Application Management (Tor ZI-A)
Kuehne + Nagel Ltd.
77 Foster Crescent
Mississauga, ON L5R 0K1
Tel: (905) 501-6596
Cell: (416) 317-3144
glenn.gundermann@xxxxxxxxxxxxxxxx
To learn more about Kuehne + Nagel Ltd, please visit our website at: www.kuehne-nagel.com For the Kuehne + Nagel email disclaimer, visit:
http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_French.pdf
Visitez le site internet de Kuehne + Nagel Lt?e: www.kuehne-nagel.com Notre d?charge de responsabilit? est disponible comme suit:
http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_French.pdf
midrange.com
