Hi All,
We are using DataStage 4.2 running on UNIX machine. I want to execute a Script on UV database as before job Subrouting using ExecTcl option.
Say for example, I want the before job subroutine as
ExecTCL : LIST DS_JOBS
I know that we can do the samething in job control using DSExecute function and thus access the output result set. I want to do the same thing in before job subroutine and how to access the result set??? I hope my question is clear.
Thanks in advance,
Bala
ExecTCL in before job subroutine
Moderators: chulett, rschirm, roy
There is no way I know of to access the result set of a before job command. You may try running that routine/command in a transformer stage variable using : IF @INROWNUM = 1 THEN ...run my routine...the result set then could be accessed through the stage variable or using named commons in DataStage basic ( would require another routine to access it though).