Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How To Resolve -219 SQLCODE Error

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

New User


Joined: 04 May 2007
Posts: 58
Location: Manila, Philippines

PostPosted: Thu Jul 26, 2007 8:06 am    Post subject: How To Resolve -219 SQLCODE Error
Reply with quote

Hello,

I am binding a group of programs but I come up with a -219 SQLCODE.
References say that "THE EXPLANATION TABLE IS NOT AVAILABLE".
I am not aware of this 'explanation table' and where to get it. Required response says to creat one but I don't know how it looks like.
I never encountered this error before so I would like to ask your expert advice on how to resolve this -219 SQLCODE error.



Regards.
Back to top
View user's profile Send private message

kgumraj

Active User


Joined: 01 May 2006
Posts: 151
Location: Hyderabad

PostPosted: Thu Jul 26, 2007 10:13 am    Post subject:
Reply with quote

Hi,

Check the Bind parametes.
Check if EXPLAIN(YES)

Remove this and bind again, I feel you will not get this error.

if possible do post Bind step
Back to top
View user's profile Send private message
Raphael Bacay

New User


Joined: 04 May 2007
Posts: 58
Location: Manila, Philippines

PostPosted: Thu Jul 26, 2007 12:02 pm    Post subject:
Reply with quote

I tried this but it did not work. I think it has got something to do with the db region I am working with. I am still investigating the cause of this problem.
Back to top
View user's profile Send private message
vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Thu Jul 26, 2007 12:10 pm    Post subject:
Reply with quote

DB2 attempted a positioned UPDATE or DELETE was attempted on a row that no longer matches its previous condition. The column values in the result table row do not match the current values in the base table row because the row was updated between the time it was inserted into the result table and the positioned update or delete was executed. cursor-name Name of the cursor used for the positioned update or delete.
Back to top
View user's profile Send private message
Raphael Bacay

New User


Joined: 04 May 2007
Posts: 58
Location: Manila, Philippines

PostPosted: Wed Aug 01, 2007 4:10 pm    Post subject: Re: How To Resolve -219 SQLCODE Error
Reply with quote

I got the cause of it. My mainframe id hasn't got update, insert and delete access in db region so I cannot bind properly. Thanks for all the advice.
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 OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us