How to call Teradata SP

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
gsherry1
Charter Member
Charter Member
Posts: 173
Joined: Fri Jun 17, 2005 8:31 am
Location: Canada

How to call Teradata SP

Post by gsherry1 »

Hello Forum,

What are the feasible/preferred methods of calling a Teradata SP from DataStage?

Given that Teradata SP do not return more than one row, I am inserting the result set from the SP into a temp table, and then I had the intention of both calling the SP and selecting from the temp table from my DS job.

Can a Teradata SP be called from DataStage?
Which of the stages support calling a Teradata SP (ODBC Enterprise, Teradata Enterprise)

How do I go about both calling the SP and selecting the result set from temporary table within the same stage. I had plans of using the 'Open Command' parameter to place a call to the SP, and using the Table or User Defined SQL to select from the temporary table. Is this the correct approach?

Thanks in advance.

Greg
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”