MVSFORUMS.com

vsr100481 · Beginner Joined: 02 May 2006 Posts: 9 Topics: 5

Hi

I have few doubts regarding stored procedures (both External Stored Procedure and DB2 Stored Procedure). Kindly advise.

1. I assume there is no difference between SQL Stored procedure and DB2 stored procedure? If it have difference, please list down those!

2. Could you please explain the program preparation steps (precompilation, compile, etc) involved in COBOL Stored Procedure (External Stored Procedure) and SQL/DB2 Stored Procedure in Detail.

3. I used to work with both COBOL and DB2 stored procedures. There we normally call a COBOL stored procedure from a front end application or through some batch program. Can I execute a COBOL Stored procedure (External Stored Procedure) using a run JCL by passing necessary inputs thru sysin cards?

4. If the above point (3rd) is possible, can you please provide me the sample JCL which calls the COBOL Stored procedure?

Please clarify.

Thanks for your support. And sorry if my question is repeated one.

With Regards
Sundar

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

Sundar,

You can get answers for your queries from DB2 material. Do not open multiple threads on the same topic.

vsr100481 · Beginner Joined: 02 May 2006 Posts: 9 Topics: 5

Hi,

It would be very much greatful if you could provide link or some good material which has program prepartion steps for COBOL and DB2 Stored Procedure and run jcl for the executing the SP'S.

And sorry for the duplicate posting.

Thanks.
Sundar

kolusu · Posted: Mon Feb 11, 2008 11:20 am Post subject:

vsr100481,

I would recommend you to go thru this excellent redbook which explains in detail about Getting Started with DB2 Stored Procedures

http://www.redbooks.ibm.com/redbooks/pdfs/sg244693.pdf
_________________
Kolusu
www.linkedin.com/in/kolusu

kalidasv · Beginner Joined: 05 Mar 2009 Posts: 13 Topics: 8

Thanks Kolusu. I started reading this redbook and it is very informative.