Execute Command Output

[sigma]

Hi

I have the following command and the output of it is 3 (as there are 3 lines in the file)
$ wc -l *Rejects.txt | grep total | awk '{print $1}'
3
$

But when I use the above command in the execute command stage I get the following

Sequence job output

Process_Customer_Master..JobControl (@Command_To_Chk_Rejects): Executed: wc -l *Rejects.txt | grep total | awk '{print $1}'
Reply=0
Output from command ====>
wc: 0653-755 Cannot open *Rejects.txt.


Not sure why it cannot open the *Rejects.txt from within the stage

-rw-r--r-- 1 dsadm dstage 21 Oct 04 14:42 Arvind_Rejects.txt
-rw-rw-r-- 1 dsadm dstage 0 Oct 04 14:42 10_SalesPerson_Rejects. txt
-rw-rw-r-- 1 dsadm dstage 0 Oct 04 14:42 10_Country_Rejects.txt


The files are there with more then a fewlines

Any ideas?. It it typically to put this in a shell script and invoke the shell script or does it take the direct command

I have pasted the entire command on the command text box and nothing on the parameter

I was expecting a command output activity variable to have value 3 to help in downstrem testing

Arvind

[ray.wurlod]

You're probably not executing in the same directory. Include a cd command in the commands executed from DataStage.

[chulett]

No probably about it. That's the perils of using a relative path.