How to call Teradata SP
Posted: Mon Jan 16, 2006 11:40 am
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
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