MVSFORUMS.com

Prosenjit2 · Posted: Wed May 04, 2005 6:18 am Post subject: DB2 stored procedure

is it possible to call a DB2 stored procedure from another DB2 stored procedure?

If yes then Please give some examples..

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

prosenjit2,
Answer is yes. Make sure what is a "Call". You may use the regular cobol call and it would be treated as such. If you use "EXEC SQL CALL" then its a Nested Stored procedure and executes in its allocated address space. Thanks

s_shivaraj · Posted: Wed May 04, 2005 11:06 pm Post subject:

SureshKumar,

Just check this Link ,Stored Procedure Link its shows that is not possible in version 4 and 5 to call another stored proc from a stored proc, r u refrerring to version above 5 ?.

Text in the Link
In DB2 Version 4 or DB2 Version 5, a stored procedure cannot use the SQL CALL statement to invoke another stored procedure.
_________________
Cheers
Sivaraj S

'Technical Skill is the Master of complexity, while Creativity is the Master of Simplicity'

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

s_shivaraj,
My mistake, its for version 6 and above. I was assuming people are out of these version 4/5 by now, probably not. Thanks for pointing out.