Hi All :)
Ok... I think someone (Maybe Ragu?) has said this already... but I
personnally always use multi pass techniques to do this...
Why? because Mike Shumko and Paul Gobes taught me to??? at least I
think that is the reason.... even my wife wonders why I do some of the
things I do when it comes to computers! hehe
Try this idea... remember that by using temp files your clean up is done for
you by the operating system when you either log off or your job logs off.
Extract from file 1 to temp_file_1
Sort on key
Extract from file 2 to temp_file_2
sort on key with same name
Extract from file 3 to temp_file_3
Sort on key with same name
Link temp_file_1 to Temp_file_2
output link file Temp_Link_file_1
Link Temp_Link_File_1 to Temp_file_3
Output to Final_file
Art "who knows... it might work? hehe" Bahrs
----- Original Message -----
From: "Rao, Ragu" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Friday, November 16, 2001 6:07 AM
Subject: Re: [HP3000-L] Suprtool Question.
> Looking into Help on LINK under Linkedit, here is what I found.
>
> " If there is more than one link record with the same key value, Suprlink
> will
> select the first one it finds. You can sort by another value
such
> as
> date-time to force a certain record to be first. Please note that this
> is
> unlike Quiz, which does a hierarchical expansion to include every
> record
> accessed. "
>
> I dont think you will be able to extract Many to many in a single pass of
> link. You would have to do multiple passes to extract the exact
conditional
> records that you are looking at.
>
> Thanks
> Raghu.
>
> -----Original Message-----
> From: Heter, Alan [mailto:[log in to unmask]]
> Sent: Thursday, November 15, 2001 4:28 PM
> To: [log in to unmask]
> Subject: [HP3000-L] Suprtool Question.
>
>
> I have 3 Self describing files created with Suprtool.
> Cust
> CUST-NBR X(1)
> ORDER-GUIDE X(1)
>
> Records in the file are:
> 1Y
> 2Y
> 3Z
>
> Item
> ITEM-NBR X(1)
> ORDER-GUIDE X(1)
>
> Records in the file are:
> 4Y
> 5Y
> 6Z
>
> Order-guide
> ORDER-GUIDE X(1)
> ALT-ORDER-GUDE X(1)
>
> Records in this file are:
> YX
> ZW
>
> I am using Superlink to put the file together
>
> LINK INPUT ITEM
> LINK LINK CUST
> LINK LINK ORDER-GUIDE
> LINK OUTPUT COMBINED
> LINK EXIT
>
> The Data I expect to see is:
> 4Y1X
> 5Y1X
> 4Y2X
> 5Y2X
> 6X3W
>
> I am getting:
> 4Y1X
> 5Y1X
> 6X3W
>
> Customer 2 is lost due to the same order guide value(Y).
> Can anyone tell me what I am doing wrong?
>
>
> Alan Heter
> Senior Programmer Analyst - Information Systems
> Alliant Foodservice - Minneapolis
> 2864 Eagandale Boulevard
> Eagan, MN 55121
> (651) 683-4206
> (651) 683-4438 fax
> mailto:[log in to unmask] <mailto:[log in to unmask]>
>
> * 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 *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|