Using unix command output in Job

saikrishna · Post by **saikrishna** » Mon Jul 14, 2008 12:38 am

Hi

How would I use the output of Unix command (for example, wc -l filename.txt) in the job?

I tried using the following options to do this work
1. We can only call the unix command in before/after job.. in which case, we cant use the return value from the output of this command...

2. One more way is using this command at sequence level, and passing the result to underlined job.. But I could not use the direct unix command in this way..
What I would like to know in this case is, is there any way to call unix command from DataStage routines...if any, please suggest me..

If you have any other approach ...please give me the suggetion.

Thanks
Sai

WoMaWil · Post by **WoMaWil** » Mon Jul 14, 2008 12:49 am

hai sai,

there are several more ways to use UNIX command within DataStage. Best to get them known is to go to a training.

Have you tried to use a UNIX-command within a Routine?

ray.wurlod · Post by **ray.wurlod** » Mon Jul 14, 2008 12:54 am

An Execute Command activity in a job sequence will execute an operating system command directly, and make its output and exit status available as activity variables that you can use to control Triggers or access in downstream activities.

Beware that the command output is converted to a single string, in particular that line terminators are converted to field marks (@FM).

saikrishna · Post by **saikrishna** » Mon Jul 14, 2008 2:26 am

Thanks Ray....