Re: Skip deleted records from a file

[Don <dr2@xxxxxxxxxxxx>]

I think you may have had more than one record you wanted to delete then...

That deleted record shown in the DSPFD should not be readable by a normal
RPG in normal circumstances....



On Mon, 22 Dec 2003, Peter Vidal wrote:

>
> "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
>
>
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>