-419 SQL error when binding

senthamizh · New User Joined: 27 Apr 2009 Posts: 23 Location: mumbai

Hi,

I am getting -419 error when i execute the below query,

Select ( REV/RMS) as xyz
from
( select sum(RMS) as RMS,
sum(REV) as REV
from table 1
)

when i bind the pgm it is failing with -419.

Both the column REV and RMS is decimal 18,4 defined in table1.

I checked in IBM site and they have said that we use to check the formula 31 - NP+NS- DS. The result should no be -ve.

in my case it is 31-18+4 - 19 = -2 because of this it is failing with -419.
I tried cast function but not solved this problem.

But i want to know how to solve this.

Thanks,

enrico-sorichetti · Posted: Sun Jun 12, 2016 8:49 pm

do not double post the same question on the sibling forum
people answering there are the same answering here.
You will not get double answers in the same time
or the same answers in half the time.
You will just pi** off people.

the topic on the other forum has been deleted

Rohit Umarjikar · Posted: Mon Jun 13, 2016 9:18 am

The database configuration setting "MIN_DEC_DIV_3" needs to be configured with the value "YES".
But send an email to DBA first and get the directions for the fix.