View previous topic :: View next topic
|
Author |
Message |
nimisanand
New User
Joined: 22 Nov 2005 Posts: 24
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Oooopps
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 |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
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 |
|
|
nimisanand
New User
Joined: 22 Nov 2005 Posts: 24
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|