Experts, I am not sure, if I am putting this problem in the right forum. But just want to have some inputs from you:-
I have created a Stored Proedure (takes a table name as an input parameter), which I am using in DataStage tool Version 8.1.
This SP is getting called in "Before SQL" property of the Teradata Connector stage. But the problem is that, the stage is not invoking this SP.
Then I successfully executed this SP in Teradata SQL Assistant & re-tried running it through DataStage job. Surprisingly, this time it ran!
But, I can't do this activity for every table in my database.
Is this seem to be an issue with the DataStage TD connector stage?