AMDP SQL dump with code : 314 (Numeric Overflow)

[sushmita_bhattacharjee]

Hi All,

I seek an help here from the experts.

For my AMDP i get an error with SQL code : 314 which is for NUMERIC OVERFLOW.

For one of my SQL queries : select ( A * B ) as "C", amdp dumps with SQL code 314.

sometimes : A might be as big as 259303135 and B might be as big as 259303135. Thus, C might get very big.

I have tried declaring C as double as well, still i get the dump.

Kindly suggest.

Regards,

Sushmita

[Former Member]

Hi Sushmita,

Declaring them as DOUBLE should solve the issue.

Regards,

Anil

[former_member186082]

Hi Sushmita,

Defining C as bigint should work.

Regards
Chandu

[sushmita_bhattacharjee]

No success Chandu. Thanks for the suggestion

Regards,

sushmita

[former_member186082]

Hi Sushmita,

What are the data types of A and B

Regards,

Chandu