DSXchange

Hi All,
I have scenario here, the job shldnt get executed when the source file is empty or with 0 records in it How to achieve this in the job? do we have use any constaints at job level

Thanks
Mandar

Perform a check of 'wc -l' via DataStage on the file before you trigger this file.

Hi sainath,

Thx for early reply
Can you be more clear on the solution i mean where should i check the "wc -l" ? my job flow is :
SeqFile--------->Transform--------------->HashFile

Mandar,

you would need to write a sequence job, in that you call the UNIX command "wc -l {yourfilename}" to return you the number of lines, then you can conditionally call a job if this returned number is greater than zero.

Hi All,
Thx very much for the i/ps i got the solution. :D