DSXchange

Hi !

I have a unix shell script to basically remove duplicates
When i run this shell script from Unix box, it works perfectly.

But when I call it from Datastage using a Execute Command stage, the gscg.srt file is always created as a blank file.

Any ideas as to why this is happening?

-Nagesh

That is odd. Are you certain you are using absolute paths, particularly for the source file? A common mistake is that the CWD for jobs started through DSExecute is that of the DataStage project directory; if the source isn't found that would explain the empty (but created) output file.

Check the director log for the exact command that been executed from Datastage.