exception error decimal overflow has occurred during multipl
Posted: Wed Nov 14, 2018 6:10 pm
Hi All,
I am trying to unload data from the DB2 table, I am getting decimal overflow error for one of the record which has values shown below.
SQL query
select
CAST(DECIMAL( F.QTY_SH_RECVD_SUOM* E.PRICE_PO ,13, 4)
AS CHAR(20)),
F.QTY_SH_RECVD_SUOM - declared as decimal(15,4) not null
E.PRICE_PO - declared as decimal(15,5,) not null
Below are the values for the particular record which is giving me an error
SELECT
CAST(DECIMAL(1190720.0000 * 1.01800,13,4) AS CHAR(20))
FROM SYSIBM.SYSDUMMY1
Just want to understand why is it failing only for this particular record.
Thanks,
Rakesh MS
I am trying to unload data from the DB2 table, I am getting decimal overflow error for one of the record which has values shown below.
SQL query
select
CAST(DECIMAL( F.QTY_SH_RECVD_SUOM* E.PRICE_PO ,13, 4)
AS CHAR(20)),
F.QTY_SH_RECVD_SUOM - declared as decimal(15,4) not null
E.PRICE_PO - declared as decimal(15,5,) not null
Below are the values for the particular record which is giving me an error
SELECT
CAST(DECIMAL(1190720.0000 * 1.01800,13,4) AS CHAR(20))
FROM SYSIBM.SYSDUMMY1
Just want to understand why is it failing only for this particular record.
Thanks,
Rakesh MS