topic Re: EG 4.2 invoke a DB2 Stored Procedure passing and receiving parametrs back in SAS Enterprise Guide

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

LS — Mon, 13 Sep 2010 15:38:39 GMT

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

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

SASKiwi — Tue, 14 Sep 2010 23:26:42 GMT

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.

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

SASKiwi — Tue, 14 Sep 2010 23:31:03 GMT

Correct link this time:

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