Calling Script from DS Routine

[SharingDS]

Hi Gurus,
I have a Shell Script (For moving files from One directory to another directory) which i want to call from DataStage routine by passing the Parameteres (As Src Directory and Tgt Directory) to the script.

Anyone tell me, Can DataStage Executes Unix Shell Script from Routine.


Thanks in Advance

[ray.wurlod]

Yes.

Code: Select all

Call DSExecute("UNIX", path_of_script, Output, ExitStatus)

The first two arguments are input, the final two are output. Output is any output from the script, ExitStatus is the exit status of the script.

[SharingDS]

Thanks a lot Ray.

I m able to do it .....