How to call a Stored procedure which is in SQL Server database in Datastage job? I want to pass job parameters as one of the SP parameters and for remaining SP parameters , I want to use default values. Also I want to perform transformation on the result set of SP.

Interview Candidate
Jun 28th, 2006
1
9608

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

rajenmari
Profile Answers by rajenmari

Mar 26th, 2007

In ODBC properties

Click on OUTPUT
General select Stored Procedure
browse to get the stored procedure if have not import then you need to import it.

try this if still have problem buzz me.

Raj Reddy