RE: Updating with the column from another file

David,

Not sure I understand the relationships between the files.... Can you at least tell us how what fields you use to do your chains? As stated, I do not understand why you must go through customer_dossier to access customer_master. Does your output contain customerID? What is the nature of the output file. I'm afraid I can't see what you are trying to accomplish with the information you provided....

FWIW, I'm certain that you *could* do this with SQL, but it is not clear how to go about it without more details.....

Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of David FOXWELL
Sent: Friday, July 18, 2008 9:04 AM
To: Midrange Systems Technical Discussion
Subject: Updating with the column from another file


Hi,



I have an old program that produces a file with, amongst other information,
$dossier, profession

The profession has to be changed so it comes from the customer master file.
$customer, profession

To get to the customer master file, I'd have to first access the customer/dossier file
$customer, $dossier

I just wasted an hour updating profession in the old file with profession from the customer master file with SQL. The problem was that there can be more than one dossier per customer.

So I'm going to write an RPG program that reads the old file, chains on customer/dossier file then on customer master file.


Was this possible in SQL?