How to retain the data of the Hash file when the sourceempty

[Mandar_Deshpande]

Hi All,

I have 2 sets of job in first jobs i am creating a sequential file,
and in the second job i will be using this sequential file to load the Hash file, but the second job should not get executed when the output of the first job i.e sequential file is empty because what happens is when my source file for the second job is empty the data in the hash file is getting overitten with empty sequential file i.e no data in my hash but my requirement is the hash file shouldnt loose the data when the source is empty.

[ArndW]

It sounds like you have the "clear file" option set when writing to the hash file. If you uncheck this then the file's contents will not get deleted on subsequent runs.

[Sainath.Srinivasan]

Mandar_Deshpande,

But what if the source file did have rows. If you then want to clear rows, I assume the requirement can be solved by performing a 'wc -l' on your seq file to determine the flow.