checking if a numeric field has gone over the size limit for the field

[andymc1]

hello

i am running a piece of sql to do a count and want to know how to check if the count into field has gone over the max value of that field (null indicator????)

all help much appreciated
Andy

 

[Crox]

Hi,

I assume you use the SQL combined with COBOL.

Checking before is perhaps the easiest way.

Define the field very large. There is always a practical limit.

The ON SIZE ERROR option can be helpful if it is your own source and not that of the precompiler.

ADD ... ON SIZE ERROR

Regards,

Crox

 

[Dimandja]

You can use SQLCODE to find out whether the count has gone over the field SIZE limit.

SQLCODE will contain 8115 (check your documentation) on a NUMERIC OVERFLOW.

Dimandja