receive return values from SQL Server 2000 Stored Procedure

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
userds
Participant
Posts: 19
Joined: Mon Feb 14, 2005 1:39 pm

receive return values from SQL Server 2000 Stored Procedure

Post by userds »

Is there a way to receive return values (a recordset or return codes) from Microsoft SQL Server 2000 Stored Procedures in Datastage Client Version 7.5.

Thanks.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Use ODBC stage. Method is Stored Procedure. Column definitions must match recordset used/generated by Stored Procedure.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”