Page 1 of 1

Calling OSH scripts from DataStage

Posted: Wed Aug 09, 2006 12:18 pm
by ds_is_fun
How could I call an OSH script from DataStage? Thx

Posted: Wed Aug 09, 2006 4:42 pm
by bcarlson
As I understand it, you can run any Unix command from within DataStage, that would include an OSH script. An OSH script is a stand-alone process. If it can be run from the command line, it can be run from DataStage.

Now, I have not created any jobs that call Unix programs, so you will need to rely on someone else for the inevitable 'How To' question. :)

Brad.

Posted: Thu Aug 10, 2006 12:03 am
by ray.wurlod
The easiest method would be to use an Execute Command activity in a job sequence.

You almost certainly do not want to call an osh script from within a job stream, because the script would then need to be invoked, start up, execute and finish for every row processed by that job.

Posted: Thu Aug 10, 2006 8:52 am
by bcarlson
ray.wurlod wrote: You almost certainly do not want to call an osh script from within a job stream, because the script would then need to be invoked, start up, execute and finish for every row processed by that job.
Good point. What Ray say.