Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor LS
Occasional Contributor
Posts: 15

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

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
Super User
Posts: 3,233

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

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.
Super User
Posts: 3,233

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

Correct link this time:

http://support.sas.com/kb/13/147.html
Ask a Question
Discussion stats
  • 2 replies
  • 106 views
  • 0 likes
  • 2 in conversation