×
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.
<snip>
For the second option, couldn't you create an on-the-fly logical to only
select the records you want, then in the RPG you could just delete them?
That way you'd get the speed of only reading the records you need, and
the
protection of record locking.
</snip>
I wouldn't think so. Better off doing a OPNQRYF but SQL is going to be
much better I would think.
As far as the record lock issue, I would issue an SQL to read only
records to delete and then issue delete for each record checking for a
record lock.
Slower than letting SQL do all the work but could let you deal with
locks.
My point being that you should never read anything into a program that
you are not planning to use and you would only need to read in the keys.
Again nothing into a program except what you need.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.
midrange.com
