Skip to Content
avatar image
Former Member

AMDP SQL dump with code : 314 (Numeric Overflow)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 19, 2015 at 11:25 PM

    Hi Sushmita,

    Defining C as bigint should work.

    Regards
    Chandu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2015 at 11:36 AM

    Hi Sushmita,

    Declaring them as DOUBLE should solve the issue.

    Regards,

    Anil

    Add comment
    10|10000 characters needed characters exceeded