Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
IBM Mainframe Forum 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

New User

Joined: 27 Apr 2009
Posts: 23
Location: mumbai

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


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

Select ( REV/RMS) as xyz
( 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.

Back to top
View user's profile Send private message


Senior Member

Joined: 14 Mar 2007
Posts: 10700
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

Global Moderator

Joined: 21 Sep 2010
Posts: 2467
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 Easytrieve EZABX007 with error code 0... Carol Schablow CA Products 7 Thu Sep 24, 2020 3:30 am
No new posts SARBCH REPORT DD writing error kris_madras CA Products 1 Tue Sep 15, 2020 4:22 pm
No new posts EIBRESP =16 & EIBRESP2 = 01 while... Farheen CICS 4 Mon Aug 24, 2020 2:05 pm
This topic is locked: you cannot edit posts or make replies. issue with Syntax error shub2204 SYNCSORT 2 Wed Aug 12, 2020 3:11 pm
No new posts Force a Return Code and print error m... Rick Ryan SYNCSORT 30 Thu Jun 25, 2020 1:18 am

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