How to call a Teradata SP in Server Job
Posted: Mon Jan 16, 2006 11:57 am
Hello Forum,
What are the feasible/preferred methods of calling a Teradata SP from DataStage Server job?
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?
How do I go about both calling the SP and selecting the result set from temporary table within the same stage?
Similar post appears in Parallel forum.
Thanks in advance.
Greg
What are the feasible/preferred methods of calling a Teradata SP from DataStage Server job?
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?
How do I go about both calling the SP and selecting the result set from temporary table within the same stage?
Similar post appears in Parallel forum.
Thanks in advance.
Greg