Search found 1 match
- Mon Apr 16, 2007 10:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calling SQL Server Stored Proc via ODBC stage
- Replies: 1
- Views: 871
Calling SQL Server Stored Proc via ODBC stage
Hi, I need to execute a Stored Procedure on a SQL Server Table, in Data Stage scenario is: SeqFile ---> Transformer-->ODBC Stage Here i am generating a single dummy record from SeqFile Stage to trigger the call to the stored proc in theODBC Stage. The call to the stored proc is working but if the st...