View previous topic :: View next topic
|
Author |
Message |
sbalajibe
New User
Joined: 15 Aug 2005 Posts: 62
|
|
|
|
Hi all,
How to call a db2 stored procedure from another sored procedure
thanks
Balaji |
|
Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
Balaji,
Stored procedures called from another stored procedure is exactly the same as calling the stored procedure from a main program. No difference.
Dave, |
|
Back to top |
|
|
sbalajibe
New User
Joined: 15 Aug 2005 Posts: 62
|
|
|
|
Hi Dave,
Can u please explaine me with some sort of code
for example i have a child stored procedure and i want to execute in the parent stored procedure then how can i code
thanks in advance,
balaji |
|
Back to top |
|
|
Mohan Makana
New User
Joined: 07 Feb 2006 Posts: 18
|
|
|
|
Hi Balaji,
If you are working on DB2 Stored procedures with Cobol, then we usually mention as
Exec-Sql
Call < Store Procedure Name> <PARM>
End-Exec.
in the cobol program. |
|
Back to top |
|
|
sbalajibe
New User
Joined: 15 Aug 2005 Posts: 62
|
|
|
|
Hi Mohan,
It is working fine
any where if u want to execute a stored procedure u can use CALL
Thanks
Balaji |
|
Back to top |
|
|
|