DSXchange

Posted: **Mon Aug 06, 2012 8:00 am**

Hi All,

Am reading a file on Extrnal Source Stage using a command below.
Am doing this because I need to remove trailer and Header Records from file before reading.

Issue is - when there are no files to load, instead of ABORT, job is throwing an warning and getting completed successfully.
Can anyone suggest a better way to abort the job when no files found.
Please see the UNIX Command used (in External source Stage) and error warning below.

Code: Select all

cat #path#/REPO.*.2012-07-11*.txt | sed '1d;$d'

Code: Select all

Warning  Message :
Source subproc: cat: PATH/REPO.*.2012-07-11*.txt: No such file or directory

Posted: **Mon Aug 06, 2012 8:34 am**

You could simply put the job in a sequence, and set the output links accordinging, ie, OK will only be triggered if the job finishes with no warnings, and a second link for Otherwise can then go to a terminate stage to stop the sequence.

Or if you wanted to go even further in the sequence, you could test for the existence of a file first with an execute command stage and not even start your file reading job.

Posted: **Mon Aug 06, 2012 11:18 am**

Thanks Shane.

But Is it possible to right some kind of unix script which I could call in External source stage or in any other DS stage and on the basis of return code , job gets aborted?Is anything like this possible (if i do not wish to create a sequence)?

Posted: **Mon Aug 06, 2012 11:39 am**

What is your runtime warning limit - any chance you could set it to 1?

Posted: **Tue Aug 07, 2012 12:35 am**

Yes. By using Execute Command stage and Terminator stages in a Sequence.

Posted: **Tue Aug 07, 2012 4:21 am**

Hi,
This code will abort the job if there are no files found.

Code: Select all

if ls #path#/REPO.*.2012-07-11*.txt  >/dev/null 2>&1;then cat #path#/REPO.*.2012-07-11*.txt |sed '1d:$d';else exit;fi

The better way would be as Shane suggested ,not to trigger the job itslef if file is not found.

Thanks,
Chetan.C

DSXchange

Abort Job when no files found (Extrnal Source Stage)

Abort Job when no files found (Extrnal Source Stage)