how to call teradata storeprocedure in datastage-px

[oracle]

Hi Guys,

I have requirement call teradata storeprocedure in datastage enterprise edition. i had tried with datastage stp stage. but it specific for oracle database only.

please help me how to call teradata stored procedure using datastage-px


Thanks & Regards
Lakshmi

[cundyp]

[quote="oracle"]Hi Guys,

I have requirement call teradata storeprocedure in datastage enterprise edition. i had tried with datastage stp stage. but it specific for oracle database only.

please help me how to call teradata stored procedure using datastage-px


Thanks & Regards
Lakshmi[/quote]

Teradata Stored Procedures can only be executed thru the Server ODBC Stage (update action, call stored procedure). We opened this as an issue with IBM: they don't recommend using Teradata Stored Procedures until Hawk. We closed the issue, they only support Data Direct Drivers and we were using Teradata Drivers.
Pete Cundy
Consultant Hallmark Cards

[DSguru2B]

You can always write a script, test it out from command line and invoke it from before/after job subroutines 'ExecSH' or a few other places.

[ray.wurlod]

What does it do? Do you want to call it row by row, or only once per run? Can you invoke it from an operating system shell (or shell script) that invokes BTEQ? If so, why not encapsulate it that way and invoke the shell script from DataStage?