nvsnaidu
New User
Joined: 09 Nov 2007
Posts: 7
Location: Chennai
|
|
|
|
Field A Decimal (15,2)
Field B Decimal (15,3)
SELECT
A / B
FROM C
WHERE ACCT_NUM = '001000020000'
I wanted to divide these two fields and i get the above SQLCODE -419 as below:
DSNT408I SQLCODE = -419, ERROR: A DECIMAL DIVIDE OPERATION IS INVALID BECAUSE THE RESULT WOULD HAVE A NEGATIVE SCALE
I tried using CAST but was not getting the values after decimal points in the ouput. please help |
|
