ERROR: Numeric overflow occurred during computation.

Tools & Utilities
Enthusiast

ERROR: Numeric overflow occurred during computation.

help with fast export

Hi,

I am using fastexport in AIX environment. i have mentioned the query as follows. please provide assistance with this query. the database has about 1 million records.

QUERY

SELECT
ID_column (DECIMAL(8,0))
,'|' (CHAR(01))
,MAX(date_column)
FROM XXXXX.XXXX_XXXX
where ID_column in (206450004012925470,200016426907279940)
GROUP BY ID_column;

error message:

 UTY8713 RDBMS failure, 2616: Numeric overflow occurred during computation.

solution:

i googled. i asked to use cast function but i don't know where to cast it.

Tags (1)
2 REPLIES
Junior Contributor

Re: ERROR: Numeric overflow occurred during computation.

Do you really think you can cast 206450004012925470 into a decimal with 8 digits?

Dieter

Enthusiast

Re: ERROR: Numeric overflow occurred during computation.

hi Dieter,

thanks for the quick reply.

I am an unix developer so , don't have much about queries.

i tried

ID_column (DECIMAL(18,0))

now, the query runs successfully but i am getting garbage values in the exported file. could you please format the query with specifiers and help me?