Re: How can one retrieve or establish the max value a numeric field can hold using SQL?

If all else fails you can use the SQL describe table command. Ysed to be that you had to use a SQLDA for that, but it is no longer the case, and that means you can use SQL commands to get at the pieces of the description. It has all kinds of info available like column name, data type, size, etc.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx



-----rpg400-l-bounces@xxxxxxxxxxxx wrote: -----


To: <rpg400-l@xxxxxxxxxxxx>
From: "Darryl Freinkel" <dfreinkel@xxxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
Date: 08/06/2010 04:44PM
Subject: How can one retrieve or establish the max value a numeric field can hold using SQL?

I have a need where I am copying data from 1 file to another where 1 or more
numeric source fields have values that are greater than the maximum value
that can be stored in the target field example 99,999.99 cannot be moved to
a field that is 999.99 long.



I need a SQL command or function that will allow me to test the values in a
CASE or CASE like statement.



I need to flag these records before I try to process them.



TIA

Darryl Freinkel