View previous topic :: View next topic |
Author |
Message |
vsr100481 Beginner
Joined: 02 May 2006 Posts: 9 Topics: 5
|
Posted: Sun Feb 10, 2008 11:23 pm Post subject: Doubts in COBOL and DB2 Stored Procedure. |
|
|
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 |
|
Back to top |
|
 |
vkphani Intermediate

Joined: 05 Sep 2003 Posts: 483 Topics: 48
|
Posted: Mon Feb 11, 2008 3:58 am Post subject: |
|
|
Sundar,
You can get answers for your queries from DB2 material. Do not open multiple threads on the same topic. |
|
Back to top |
|
 |
vsr100481 Beginner
Joined: 02 May 2006 Posts: 9 Topics: 5
|
Posted: Mon Feb 11, 2008 6:35 am Post subject: Doubts in COBOL and DB2 Stored Procedure |
|
|
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 |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
kalidasv Beginner
Joined: 05 Mar 2009 Posts: 13 Topics: 8
|
Posted: Tue Mar 17, 2009 12:17 am Post subject: Doubts in COBOL and DB2 Stored Procedure |
|
|
Thanks Kolusu. I started reading this redbook and it is very informative. |
|
Back to top |
|
 |
|
|