MVSFORUMS.com

valeti_sashi · Posted: Wed Sep 13, 2006 11:17 pm Post subject: Building SQL Stored procedure

Hi,

i had created a pure SQL stored procedure in DB2. Now the question is how to build/compile it. is there any command in SQL itself like Compile in oracle or do we have to use a JCL compiler for binding it. it if we have to use the JCL compiler, please send me the send also.

please help me in this concern.

Regards,
Sashidhar

shekar123 · Posted: Wed Sep 13, 2006 11:37 pm Post subject:

valeti_sashi,

Check this link which explains everything about DB2 Stored Procedures:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/6.2?DT=20010710165542
_________________
Shekar
Grow Technically

valeti_sashi · Posted: Wed Sep 13, 2006 11:43 pm Post subject:

Shekar,

I know how to create and execute Stored procedure. In between these two we to compile the procedure. I want, how to do that.
_________________
Regards,
Sashidhar

shekar123 · Posted: Wed Sep 13, 2006 11:51 pm Post subject:

valeti_sashi,

Can you go through the section for the following topics ?

6.2.4.11 Preparing a stored procedure
6.2.4.12 Binding the stored procedure

Please let me know if you need more info.
_________________
Shekar
Grow Technically

valeti_sashi · Posted: Thu Sep 14, 2006 12:02 am Post subject:

Shekar,

i already have this PDF and gone thru it. But this doesn't answer my question.

shekar123 · Posted: Thu Sep 14, 2006 4:18 am Post subject:

valeti_sashi,

Sorry i do not have the Compile JCL with me and i am not sure about the changes in the JCL .But the process is you have to create a load and a package for the SQL statements in the procedure by normal compile and bind process.
_________________
Shekar
Grow Technically