Hi John
I think this is something to do my thread, but the subject line has changed
So here goes
this is a manual process
If customer 1 is
Richard Heinlein
123 Main st
Anytown, NY 10001
and customer 5437892 is
R Heinlein
123 Main St
Anytown, NY 10001
you CANNOT guarantee that these are one and the same, because R Heinlein
could be his wife Roberta
The only true way for this merge to be accomplished is if the customer
themselves says so, so in this case, a user would be responsible to merge
these 2 records because the customer has requested to do so. If there is
other such records that the customer wants to be merged, then customer
record 6873222 would also need to be merged with customer 1, but as a
seperate process.
Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
"Voris, John"
<john.voris@crown
cork.com> To
Sent by: <rpg400-l@xxxxxxxxxxxx>
rpg400-l-bounces@ cc
midrange.com
Subject
EXTNAME ( MyDSPF : MyFormat )
11/18/2009 11:21 (David FOXWELL)
AM
Please respond to
RPG programming
on the IBM i /
System i
<rpg400-l@midrang
e.com>
But good old Mister Murphy . . .if someone can see a hole in my
thought pattern,
Are you sure that the customer record is only in the file twice?
Is there a chance that it if in the file three times?
If so, are you going to make two passes through the file to do the
merge?
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
