EG 4.2 invoke a DB2 Stored Procedure passing and receiving parametrs back

[LS]

Hi Guys,

I am looking for code example and tips on how to invoke a DB2 stored process where I pass parameters and the procedure sends back parameters to my EG session.
Thank you all for your help

[SASKiwi]

I suggest you search the SAS support site as I was able to find numerous references including this one:

<>

In a nutshell you need to write an SQL PASSTHRU query and use the EXECUTE facility to do this. Parameters can be passed back as well as supplied using DB2 SQL syntax.

[SASKiwi]

Correct link this time:

http://support.sas.com/kb/13/147.html