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