don't want to create empty SORTOUT file

mvfligel · New User Joined: 18 Jul 2006 Posts: 4

I use SORT FIELDS=COPY
INCLUDE COND=..

Sometimes I got empty output files.
What should be done if I don't want to create an Empty file?

twissi · Posted: Thu Jul 20, 2006 11:16 am

It's quite obvious that no records in the input file has satisfied the condition.

If you don't want the output file to be empty, write a literal record (something like a HEADER of a report file) to the output always.

Hope this helps!

Cheers, Twissi.

Hanfur · Active User Joined: 21 Jun 2006 Posts: 104

Mv,
Create the sort output file then use COUNT FROM(IN) EMPTY option in Icetool to see the temp file which u created have data or not.You can check this using the retrun code and accordingly add one more step just to Delete it using IEFBR14 if data present else bypass the delete step..

Not sure any shortcut is there in place for this.

-Han.