How to call MS SQL Server stored procedure

xch2005 · Post by **xch2005** » Mon Sep 05, 2011 3:42 am

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

arvind_ds · Post by **arvind_ds** » Mon Sep 05, 2011 4:26 am

Use Stored Procedure stage.It supports SQL server also.

chulett · Post by **chulett** » Mon Sep 05, 2011 8:14 am

Not on UNIX. I would guess you'd need the appropriate ODBC drivers and then use the ODBC stage.

xch2005 · Post by **xch2005** » Wed Sep 14, 2011 11:50 pm

Used ODBC to connect to SQL Server DB after the ODBC configuration is done.
Thanks all.