Calling a MSSQL server Stored procedure

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
ZDC
Premium Member
Premium Member
Posts: 15
Joined: Fri Nov 23, 2007 5:06 am

Calling a MSSQL server Stored procedure

Post by ZDC »

Hi,

I need to call a MSSQL server stored procedure from DS and the stored procedure stage in this version only supports Oracle .

Is there any way I can call this SP other than using SP stage?

I found Ray's comment saying it can be done using an ODBC stage (?)

thanks,
Zero Degree Consulting
Post Reply