× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. May 2011

Re: Run SQL Scripts and File Locks

Charles wrote:

1) Quit using CLRPFM - it's designed only to be used when you can
guarantee exclusive access to a file. That's hard to do now-a-days
and if you're allowing the file to be queried at any time you simply
can't make the guarantee CLRPFM requires. I created a CLRPFMSQL
command that uses SQL DELETE to delete all records in a file. At
v5r2(?) and higher the SQL DELETE usually performs just as fast as
CLRPFM as it will do a clear if possible, or a change file, or as a
last resort individually delete the rows.

We have taken a similar approach with a local CPYFSQL
command that uses SQL DELETE to avoid exclusive
access issues - and our investment has been
rewarded with the near 24/7 we have "now-a-days"

Note: SQL will not copy invalid data, where CPYF
typically would, so some legacy file systems,
such as ours, could have issues if this approach
is used.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.