Page 2 of 2

Re: How to handle empty input file

PostPosted: Wed Oct 14, 2009 1:07 am
by Jegan R
Hi,

As you said, this is not the 'true Empty file'. So we cant even check for File Empty. If the Input file for this Ezytrieve is Empty means, we will bypass the step.But how can we check whether this is empty or not? because it doesnt have proper EOF.

Re: How to handle empty input file

PostPosted: Wed Oct 14, 2009 2:07 am
by dick scherrer
Hello,

Someone needs to change the step that creates the "empty file" so that it will have a true eof, have a dummy record that signifies "empty", or set a condition code when no output is written so that the Easytrieve step can be bypassed.

Something that could work also is to add a step before the SAS process to catalog a "good" empty file and then MOD onto it in the SAS step - i've not tested this, but it should be easily tested. . .