Hi Matthew,

You're a star.... Although I need to define the files again in suprtool
so that they're SD files the (supr)link appears to have worked fine.

Many thanks for that.

Regards,

Nige...

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Matthew Perdue
Sent: 19 April 2006 09:09
To: [log in to unmask]
Subject: Re: [HP3000-L] Merging data files ( records ) with Suprtool

Yes you can do this with Suprtool. You'll need to use the LINK command;
some DEFINEs; "OUTPUT filename, LINK" and some work files (three of
them, the 3rd being your target result). Of course some may be able to
create that file with two work files... or one... (anybody remember the
show "Name That Tune"?).

Quoting Nigel Skeet <[log in to unmask]>:

> Hi all,
>
> As per the subject can it be done ?
>
> I have 2 data files with different data in although they have a common

> record of the first 8 characters. Not all the records in file 2 will 
> be in file 1 but the ones that are I'd like to take field 9 through 
> field 80 and attach it to each record in file 1. Hopefully ending up 
> with a third file of the 2 merged together.
>
> If it's not possible with Suprtool any other ideas ?
>
> If not I'll just write up some JCL to read each record in file 1 and 
> where there's a match in file 2 add the data as required.
>
> TIA.
> nige....

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *