MVSFORUMS.com

[srikanth.bh]

Hi all,

We have created a stored procedure using dynamic SQL programming. also we are using changeman for compilation and binding. the pgm which calls stored procedure is getting executed. but the stored procedure is not being executed even after "EXEC SQL CALL PROC(<parms>) END-EXEC" being executed. the steps before and after the stored proc call, in the calling pgm are getting executed without any error message or abend.

to check whether there is any problem with bind or anything, jus before the stored procedure is called we executed a sample query and observed the SQLCODE. we were getting all wierd SQLCODES like "000000080N"
we tried executing the stored proc directly without a calling pgm. but that is also failing with another wierd sqlcode "000000099J". really not sure on where the problem might be. can anyone please suggest.

[kolusu]

Srikanth,


The sql codes 000000080N translates to -805 and here is an explanation of that

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.378?SHELF=&DT=20010718150520&CASE=

The sql codes 000000099J translates to -991 and here is an explanation of that

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.432?SHELF=&DT=20010718150520&CASE=

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[kolusu]

Srikanth,

If you have any further questions please post it here it self. Please do not send private emails. Any way your offline questions are answered in this post

http://www.mvsforums.com/helpboards/viewtopic.php?t=2086&highlight=stored+procedure

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu