View previous topic :: View next topic
|
Author |
Message |
ssowmya
New User
Joined: 10 Oct 2006 Posts: 40
|
|
|
|
Hi
Could anyone please let me know how to execute a COBOL stored Procedure???
Thanks & Regards
Sowmya |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
Quote: |
how to execute a COBOL stored Procedure??? |
Are you talking about Copybooks ? |
|
Back to top |
|
|
surya_pathaus
Active User
Joined: 28 Aug 2006 Posts: 110
|
|
|
|
Hi,
You can execute Stored Proc using DB2 CONNECT. It is an IBM tool.
Thru JCL also you can execute stored proc as like COBOL DB2 program.
But you need to do few changes to execute.
1) Because whatever inserted into Temporary Table cannot be viewed. So you need to add a file to view the records which are inserted into Temp Table. |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
Hello,
A stored procedure is written in 4th generation language. i.e, SQl. It is usually located in server location (OS). You can connect from mainframes via Connect statement in Sample Cobol or any other language.
Syntax is like this
Exec SQL
Connect <Location>
End-exec. |
|
Back to top |
|
|
|