ExecTCL in before job subroutine
Posted: 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
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