Re: Skip deleted records from a file

If it shows up in deleted records it is a hard delete.  The database has 
no way of knowing which field in the file you are using as a soft delete.

What makes you think that you are seeing this deleted record also?  If you 
were to clear myfile2 and reprocess this file, would it write 1970219 
records or 1970220 records?  If it's reading the deleted record it should 
be writing 1970220 records.  I doubt it.


CREATE TABLE ROB/PETER (MYCHAR CHAR (5 ) NOT NULL WITH DEFAULT)
Table PETER in ROB created but could not be journaled. 
INSERT INTO ROB/PETER VALUES('D') 
1 rows inserted in PETER in ROB. 
INSERT INTO ROB/PETER VALUES('x') 
1 rows inserted in PETER in ROB. 
delete from rob/peter where mychar='x' 
1 rows deleted from PETER in ROB. 

dspfd rob/peter
Total records  . . . . . . . . . . . . . . :                 1
Total deleted records  . . . . . . . . . . :                 1
Remember that Total records does NOT include the deleted records.  If it 
did, then it would show 2; the 'x' and the 'D'.

Rob Berendt
-- 
"All creatures will make merry... under pain of death."
-Ming the Merciless (Flash Gordon)




"Peter Vidal" <Peter_Vidal@xxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/22/2003 03:55 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
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




_______________________________________________
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.