Re: Skip deleted records from a file

"Hard delete or soft delete?  A hard delete should not have been read at
all.  A soft delete could be handled via one of two ways:  Process a
logical which excludes soft deletes or via program logic."

Rob: I guess is a soft delete.  If I do a DSPFD, that lonely deleted record
count is there...

"what do you mean by "deleted"?  If you did a DELET op on it, you shouldnt'
be seeing it....at least not through normal means...it's still there until
you do a RGZPFM...but, I don't see where this pgm should be seeing that
record....  Sure you actually deleted it??"

Don: I did not delete it.  We have a test environment that we "refresh" from
time to time using the *LIVE library.  This record is deleted there as well.
That is why we have it like this in the test.

The input file has this at the bottom of the DSPFD command information:

Total number of members  . . . . . . . . . :                 1
Total number of members not available  . . :                 0
Total records  . . . . . . . . . . . . . . :           1970219
Total deleted records  . . . . . . . . . . :                 1
Total of member sizes  . . . . . . . . . . :         469770240

Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com

"Have a very Merry Christmas and a more blessed new year 2004 and remember:
JESUS is the reason for the season."
Myself