Re: Remove duplicate records

[CRPence <CRPbottle@xxxxxxxxx>]

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