Re: File already in use by CL

[rob@xxxxxxxxx]

How's about a simple 'delete from ftpout' sql statement?  I find this trick
quite handy when either
a)  The file thinks it is locked
b)  The user has *change and not *all authority to the file.  CLRPFM won't
work in that situation.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    darren@dekko.com
                    Sent by:                  To:     midrange-l@midrange.com
                    midrange-l-admin@mi       cc:
                    drange.com                Fax to:
                                              Subject:     File already in use 
by CL

                    02/27/2002 08:28 AM
                    Please respond to
                    midrange-l







I have a CL program which does the following:

DCLF(FTPOUT)
CLRPFM (FTPOUT)
...fill FTPOUT during a scripted FTP process
...do RCVF for the records in FTPOUT to check for errors

CALL(FTP2PGM)

Second program:
PGM(FTP2PGM)
DCLF(FTPOUT)
CLRPFM(FTPOUT)
...similar to previous process


The 2nd program errors out during the CLRPFM(FTPOUT) with an error saying
that the file is already in use.  I'm assuming that this is from the first
program already opening the file and calling a second CL which also tries
to use the file, but I'm not really sure what's going wrong.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.