MVSFORUMS.com

[vijay]

Hi ,
I've the following values in 3 columns

column definitions:

A DECIMAL(17, 2) NOT NULL
B DECIMAL(17, 2) NOT NULL
C DECIMAL(15, 8 ) NOT NULL

column values:

A B C
.00 999989990000000.01 1.00000000
.00 999989990000000.01 1.00000000

IN 2 ROWS

i get an sqlcode 802 on this sql.can u help me what I need to here to get the final value .

[kolusu]

vijay,

If your intention is to use only 2 decimals then you need to cast column C with 2 decimals instead of 8.

try this sql

[vijay]

thanks kolusu.it worked