calling Teradata Procedure

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

You can only execute stored procedures form native api stages. Any return values will be either ignored and or the stored procedure wont run.
Its better to create a small script that fires off your stored procedure and gets the return code. This way you can fire off the script in the before/after job routine ExecSH.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply