how to not create sequential file if there are 0 records

RiyaNY · Post by **RiyaNY** » Sun May 05, 2019 4:40 pm

Hi,
Almost summer

I have a parallel job that creates a sequential file.
I want the first row to have column names.
I also do not want the file to be created if there are zero records being processed. Currently the job creates a file with just column names in this case.
Is there a way to achieve this?

kind regards,
Riya

chulett · Post by **chulett** » Sun May 05, 2019 7:17 pm

Short answer: you can't. Longer answer: don't run the job when your source is empty, check before and then run conditionally. Worst case: build something to run After Job and delete the file if it is "empty".

UCDI · Post by **UCDI** » Mon May 06, 2019 3:13 am

you can get the count of records and conditionally bypass the file creation if you are willing to move the parallel job into a sequence job and break it up. Is it worth it?