jmmckee wrote:
I think I see the logic to do this with a relatively simple RPG
program. I have managed to create a base file that has ACCT, CYC#,
DATE, TIME, and poster id. Seems like I have to do is read a record
from this file, chain to the multiformat logical, check which record
format was read, check the poster id (not in an index) and, if it
matches, delete the record. Seems too simple. Then, when done,
repost the original records.

I had wondered if SQL could do that to remove the uncertainty of
a one shot program.

Seems reasonable, but an SQL statement can probably perform the same without any program; i.e. just one dynamic statement. So I was suggesting that if the scenario were described less with words, and more with scripted create & insert, then the scenario may be clearer to someone who might then be able to suggest some simple SQL DELETE statement. However without that information, there were likely to be postings suggesting solutions that were of no help because of mis-inference about the what and how of the files & data involved, and\or hesitation to post for lack of necessary detail to be sure any response would be worthwhile. For example was my inference of what the files & data correct? I bet not, but what I presented did not seem to me, to contradict any of the given text. And in this post there is now mention of MFLF versus JLF.? No matter, I was just trying to suggest [what IMO is] a better way to present the problem.

Regards, Chuck

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].