how to execute teradata SP in Datastage.

rakesh.nc · Post by **rakesh.nc** » Mon Dec 10, 2007 7:40 am

We are trying to execute teradata stored procedure in datastage.
Can anyone suggest a way to do this.

chulett · Post by **chulett** » Mon Dec 10, 2007 8:16 am

Have you tried using the ODBC stage?

rakesh.nc · Post by **rakesh.nc** » Wed Dec 12, 2007 3:08 am

chulett wrote:Have you tried using the ODBC stage?

yup... ODBC stage dont have an option to exec Teradata SP's

shershahkhan · Post by **shershahkhan** » Fri Jan 25, 2008 5:34 am

Create a bteq scrript call the procedure from that bteq and then run the bteq through command stage or Activity stage in Sequence, In TD you cannot return dataset from SP so i am expecting you don't want output from the SP. As this post is old so if you have any other solution please share with us