IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Abend U0100 due to SQL CODE -924
IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
ponnu116
Warnings : 1
New User


Joined: 12 Sep 2007
Posts: 21
Location: chennai
PostPosted: Tue Oct 07, 2008 3:48 pm
 Reply with quote
Im getting Abend U0100 due to SQL CODE -924.

The query is fetching a cursor which was a update cursor with hold.

Can anyone please help me on this
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
PostPosted: Tue Oct 07, 2008 3:56 pm
 Reply with quote
What was the explanation from the -924 message code ?

You need to post the error messages and codes to supply us with more detail
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
PostPosted: Tue Oct 07, 2008 3:59 pm
 Reply with quote
Quote:

-924 DB2 CONNECTION INTERNAL ERROR, function-code, return-code, reason-code

Explanation: Connection to DB2 has failed because of an unexpected internal error, identified by the 'reason-code'.

System action: The statement cannot be executed. The connection to DB2 is not established.

Programmer response: Look up the abend 'reason-code' in Part 3, “DB2 codes” for further information. The requested 'function-code' and 'return-code' may provide additional information. Any attempts to issue SQL statements following the SQLCODE -924 will cause unpredictable results. SQLSTATE: 58006


the above is from Vsn 8, but is basically valid for 6 & 7.

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNC1J12/2.3.442?SHELF=&DT=20070111144235&CASE=

here is a link for the reason code: publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNC1J12/3.0?DT=20070111144235#HDRARC

suggest you download the PDF.

you can also find explanations for error at the IBM LookAt site:
www-03.ibm.com/systems/z/os/zos/bkserv/lookat/

suggest you bookmark that link.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 

Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts ISAM and abend S03B JCL & VSAM 10
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us