Using DB2 Stored Procedures

PNSimoes · November 17, 2006, 10:39pm

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.

Daniel_Wilson · November 17, 2006, 10:43pm

Sure. Use the CALLDBPROC statement.

PNSimoes · November 17, 2006, 10:56pm

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

Daniel_Wilson · November 17, 2006, 10:58pm

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

PNSimoes · November 17, 2006, 11:06pm

Natural DB2 Installed and both with version 4.1.4

Daniel_Wilson · November 17, 2006, 11:13pm

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]