DSXchange

DS_AUDIT will have information only if the jobs are modified or created.
All these are of OS related query which can be tracked by Unix admin.

Other way is, you can produce the file as DD_SAP_1.CSV and you can use in after job subroutine in ExecSH.

Are you refering to BASIC Routine?
If so Call DSExecute can be used to call OS commands. Through which you can call DB2 commands.

What trigger condition is mentioned?
You can use ReturnValue [Conditional] as trigger and specify the exact value that is retured by the script. May be "0" in your case.

Hope you are using the password that has been encrypted by Datastage.
Check the job properties is also enabled with Encryption.
Will the job work if the same password is passed from the job when triggered indivudually?

Was you OCI stage loaded later after installaion or not installed properly. Try with proper reinstallaion.
Try the dspackinst available under $DSHOME/bin by passing the corresponding project directory.
Or the same available in your server software CD.

Hi Ragunathan,
Pls delete the other duplicate post created on the Server forum.

It is very much like you execute your OS command.
You have Command line call facility avaialble in DB2.
>db2 connect to database.....
>db2 "select * from .....";
You need to wrap this command as the OS comand call.

This is really horrible .
I guess there is some change going on in the home page. I got the same multiple post in other thread, but deleted it. Not it is not possible in this one.

Dont you have the buffering property to edit in Database stage output tab?

Dont you have the buffering property to edit in Database stage output tab?

I was refering to the file which actually refer the node name.
I think, I got some ample time to do Export/Import .

Dont just get carried away from the work Panthom. It is just the DataStage internal representaiton of the each processes.
Look at "Square root of a negative number" and check your transformation logic in transformer.

Perhaps using the same Transofrmer stage to fetch first 4 char(may be after Trim()) and map to Char(4). If its sure that, the input may not contain more that 4 char.

As mentioned by Craid, the time taken by STOP signal to activate will the big impact, if the jobs are triggered in parallely. You assure about the stopping of process. It also depends on the volume of the data that been processed during that time. Which inturns decides the time of the job run.