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?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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.