RE: Clearing a physical file

Ok, thank I will give all of them a try.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Friday, March 31, 2006 7:16 AM
To: Midrange Systems Technical Discussion
Subject: Re: Clearing a physical file

Dwayne,

There are a few ways to do this.

Most efficient:  Use QCMDEXC to execute CLRPFM.  See the archives for
code 
samples involving QCMDEXC
Pro's:  efficient.  Will actually removed deleted records from the file 
freeing up that space.
Con's:  May need an exclusive lock on the file.  Users will need a
higher 
level of authority to the file to do member type commands.  I know they
do 
for ADDPFM or RMVM.  I think they do for CLRPFM.

Alternative 1:  Use an RPG loop to delete every record.
Pro's:  No file lock or additional level of security (provided they 
already have delete authority.
Con's:  Not as fast as CLRPFM.  Will not remove deleted records.

Alternative 2:  Use embedded sql: delete from myfile
Pro's con's:  See alternative 1

YMMV if you have "reuse deleted records" set to yes on the file.

Rob Berendt