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 in Non-DB2 programs calling DB2 Programs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
srikar tenali

New User


Joined: 07 Feb 2007
Posts: 22
Location: hyderabad

PostPosted: Sat Aug 02, 2008 3:45 pm    Post subject: Abend in Non-DB2 programs calling DB2 Programs
Reply with quote

I have coded a DB2 subroutine which is called by different programs. i am facing problems in running these.
1. An IMS program calling a DB2 program. Though the program is running without any abend but the SQL statements in Subroutine are returning a code -922.
2. A cobol program calling DB2 program. I used IKJEFT01 to run this program with the calling program name and called program plan details. Its abending with code U0201.

What more steps do i need to take care in running these jobs?

Thanks in advance,
srikar
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 Aug 02, 2008 10:10 pm    Post subject:
Reply with quote

Hello,

At the top of the page is a link to "IBM Manuals". Among these is the DB2 Messages & Codes that you want to learn to use. The -922 is easily found using the search feature in that manual (the yellow flashlight/tubelight). If you find something that is not clear, post what you found and your question about what you found (the -922 is a security/authorization problem).

The U0201 is a User abend. You need to look at whatever raised this abend and learn why the abend was issued. This is not a system standard abend, but specific to the code that raised the abend.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1239
Location: Richfield, MN, USA

PostPosted: Mon Aug 04, 2008 9:56 pm    Post subject:
Reply with quote

I've encountered one exception to the Uxxxx messages. IMS sometimes issues these, but they all fall within a particular range. See your IMS manuals.
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


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