How to call a Teradata SP in Server Job

[gsherry1]

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