Stored Procedure issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kool78
Participant
Posts: 104
Joined: Sat Aug 20, 2005 2:02 pm

Stored Procedure issue

Post by kool78 »

Hi,

How to execute a SQL server stored procedure for each row. The SP has two input parameters and one output parameter.

I need to execute the SP for each row of my result set and generate an output result set.

We are on 7.5.1a version and stored procedure stage doesnt allow to execute MSSQL stored procedure.

thanks in advance!
"Attitude always and almost determines the altitude of your Life"
Top
HariK
Participant
Posts: 68
Joined: Thu May 17, 2007 1:50 am

Re: Stored Procedure issue

Post by HariK »

You can execute SQL Server Stored procedure using ODBC stage. Not sure though about row by row execution.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”