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
 
Abend U0100 due to SQL CODE -924

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
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    Post subject: Abend U0100 due to SQL CODE -924
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: 8593
Location: Back in jolly old England

PostPosted: Tue Oct 07, 2008 3:56 pm    Post subject:
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: 6968
Location: porcelain throne

PostPosted: Tue Oct 07, 2008 3:59 pm    Post subject:
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.

http://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: http://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:
http://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    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Speed-up/reduce CPU use of code prino PL/I & Assembler 0 Tue Sep 26, 2017 12:05 am
This topic is locked: you cannot edit posts or make replies. how to code for GDG in Rexx cvnlynn CLIST & REXX 13 Wed Aug 09, 2017 9:13 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am
No new posts I want to retire TRX and use only Rex... Abhinav Sharma CLIST & REXX 6 Sat Jul 29, 2017 2:53 am
No new posts UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm

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