Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
-419 SQL error when binding

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
senthamizh

New User


Joined: 27 Apr 2009
Posts: 22
Location: mumbai

PostPosted: Sun Jun 12, 2016 8:20 pm    Post subject: -419 SQL error when binding
Reply with quote

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,
Back to top
View user's profile Send private message

enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10492
Location: italy

PostPosted: Sun Jun 12, 2016 8:49 pm    Post subject: Reply to: -419 sql error
Reply with quote

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
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1965
Location: NY,USA

PostPosted: Mon Jun 13, 2016 9:18 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Error while initiation CICS program f... Ashishpanpaliya CICS 3 Mon Jul 16, 2018 5:12 pm
No new posts ERROR - NO ESD ENTRIES, EXECUTION IMP... Ashishpanpaliya COBOL Programming 6 Thu Jun 21, 2018 8:57 pm
No new posts BAMAD file IO Error m1985nehal CICS 1 Fri May 25, 2018 11:51 am
No new posts DB2 Sql Error code -204 rohit_naidu DB2 5 Fri May 18, 2018 4:40 pm
No new posts Trap the jcl error message or maxcc i... ankita agarwal CLIST & REXX 5 Fri May 18, 2018 2:08 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us