Re: Clearing Physical Files in Use

Brian,

not without a lot of work.

what is the purpose of clearing the file?  depending on the situation,
you might think about doing an sql delete of all records in the file,
instead of clrpfm.  users would not need to be out of the file in this
case, though record locks would pose a problem.

if you do, change the file to reuse deleted records.

On 8/12/05, Brian Piotrowski <bpiotrowski@xxxxxxxxxxxxxxx> wrote:
> Hi All,
> 
> 
> 
> I have a batch program that runs a series of CLRPFM commands.  However,
> if someone is looking at one of the open files, I will get a LCKW
> message until that person leaves the program.
> 
> 
> 
> Currently, I have this in my CL program:
> 
> 
> 
> CLRPFM     FILE(DMDPG_PF)
> 
> MONMSG     MSGID(CPF0000)
> 
> 
> 
> Can someone tell me if there is a way to clear out the physical file
> without having to kick the user out first?  If not, what extra code (if
> I can) do I need to add to my CL program to force the user out so I can
> clear the PF?
> 
> 
> 
> Thanks!
> 
> 
> Brian.
> 
> 
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
> Brian Piotrowski
> 
> Specialist - I.T.
> 
> Simcoe Parts Service, Inc.
> 
> Ph: 705-435-7814 x343
> 
> Fx: 705-435-6746
> 
> bpiotrowski@xxxxxxxxxxxxxxx
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>