how to call a stored procedure from sql server to etl job?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vamsipx
Participant
Posts: 3
Joined: Wed Aug 22, 2007 11:31 pm

how to call a stored procedure from sql server to etl job?

Post by vamsipx »

stored procedure
Top
saikir
Participant
Posts: 92
Joined: Wed Nov 08, 2006 12:25 am
Location: Minneapolis
Contact:
Contact saikir

Post by saikir »

Hi,

If you query is to call SQL stored procedure with in an ETL job, you can do that using the ODBC stage.

Sai
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 »

No question has been asked.
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> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”