Hi,
I actually need to use MS SQL Server stored procedure in a parallel job, earlier stored procedure was in Sybase so STP (stored procedure stage) was used.
The strored procedure actually returns 2 columns which are passed to join stage and this is one of the source stages.
Appericiate any help on this. Please let me know how to execute a stored procedure (MS SQL Server) ie. which stage is feasible and how?
Thanks
How to call MS SQL Server stored procedure
Moderators: chulett, rschirm, roy