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

Moderator


Joined: 14 Mar 2007
Posts: 10472
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: 1896
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 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 4 Fri May 18, 2018 2:08 pm
No new posts Getting an error from EZASOKET while ... vaibhav gs COBOL Programming 4 Thu May 17, 2018 9:21 pm
No new posts Error executing Java program in OSGI ... danik56 CICS 0 Thu Apr 26, 2018 12:16 am
No new posts 3270 Data stream error Benchwarmer CICS 6 Tue Apr 17, 2018 12:06 am

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