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
 

 

Abend U222 when handling sqlcodes in the program

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

New User


Joined: 22 Nov 2005
Posts: 23

PostPosted: Sat Mar 17, 2007 2:01 pm    Post subject: Abend U222 when handling sqlcodes in the program
Reply with quote

Hi,

I have a select query which can yield me one row or no rows. i have done error handling when sqlcode is not = +100 and sqlcode is not = +000. i have not handled the code for sqlcode =+100. I am getting a u222 abend when i run the job. can someone tell me y this is happening?

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

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Mar 17, 2007 8:38 pm    Post subject:
Reply with quote

Hello,

Become familiar with the "Completoin Codes" part of the "MVS System Codes" manual which is linked to the "Manuals" link on the top of the web page.

An s322 abend is because the operator (or automation) canceled the job.

In your case, this probably happened because the program was or appeared to be in a loop.

Look at the code and determine if it will always proceed, rather than repeating the same set of code over and over. One guess is that the program keeps trying to "read" when it should not.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Mar 17, 2007 10:20 pm    Post subject:
Reply with quote

Hello,

Oooopps icon_redface.gif

Not only did i mis-read the post, i typo'ed the response.

This
Quote:
An s322 abend is because the operator (or automation) canceled the job.
was supposed to be s222 - which was not the U222 posted.

Bad day at eyeball/keyboard coordination.

To continue - has this program ever run successfully or is it a new program?

It appears there is a UDP open failure.
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Wed Mar 21, 2007 1:35 pm    Post subject:
Reply with quote

Is that failing at select query..? What is the sql code you are getting..?
The return code says its a User abend. May be some thing wrong in the application program. If its Pl/1 what is the ONCODE ..?
Back to top
View user's profile Send private message
nimisanand

New User


Joined: 22 Nov 2005
Posts: 23

PostPosted: Sun Mar 25, 2007 6:05 pm    Post subject:
Reply with quote

Hi,

This is an existing program. I just introduced a new query in it. The program abended with U222 and said it is not able to recognize what it needs to do when sqlcode = +100.

Regards,
Nimi
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Mar 25, 2007 7:10 pm    Post subject:
Reply with quote

Hello,

Does this mean that the program itself issues the U222 abend?

Please post the "new" query and the sqlcode checking as well as the code that generates the U222.

Whe nwe can see what you are working with, we may be able to offer suggestions.
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 IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm


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