ExecTCL in before job subroutine

vbalacts · Post by **vbalacts** » Wed Jul 24, 2002 11:35 pm

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

cmueller · Post by **cmueller** » Tue Jul 30, 2002 7:39 am

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).