Using DB2 Stored Procedures

, , ,
1

I’ve a Stored Procedure on a DB2 Database that I would like to call from a Natural Object (SubProgram)

It is possible?

thanks in advance.

2

Sure. Use the CALLDBPROC statement.

3

Even in a Mainframe Natural? Cause I searched for the command help and it wasn’t possible to find…

4

What version of Natural are you on and do you have Natural DB2 installed?

5

Natural DB2 Installed and both with version 4.1.4

6

Hmmm… There isn’t any help inside of Natural for this command or any other DB2 statement for some reason, but it is documented in the web-based documentation. Try this link:

[url]http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat422mf/sm/calldbpr_sql.htm#calldbpr_sql[/url]