I was thinking of a similar solution, but the op said that they have lots of disks space, so I am thinking why not just add the field from the other file into the your reporting file.
David A. Green (480) 813-1725 DAG Consulting -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett Sent: Thursday, October 18, 2012 8:10 PM To: U2 Users List Subject: Re: [U2] Speeding sort however the absolute fastest would be to add an itype to FILE-1 that accesses FILE-2 SORT_VALUE [you're already prepared to do multiple read on 2 files ] OTH_FILE_SORT_KEY <001> I <002> TRANS('OTHER_FILE', SOME_KEY, '', 'X') where SOME_KEY is the value you were saving from your example below and using as key to the second file FANCY_ITYPE <001> I <002> OTH_FILE_SORT_KEY : '*' : SOME_KEY etc {you could combine these two - separated for clarity} The index on FILE-1 remains THIS_FILE_FIELD then Step 1 --------- SELECT FILE WITH *THIS_FILE_FIELD*='VALUE' SAVING UNIQUE FANCY_ITYPE NO.NULLS -- gives you a list that is complete (ie doesn't need to access the other file again) -- the combo key doesn't detract from the "unique" because the other-file accesses are done using SOME_KEY -- the SAVING is doing the ITYPE work, using a reduced list, thereby saving more processing Step 2 --------- Your final step is to sort a list -- altho this represents another step, it does not involve reprocessing a file, and therefore should be very quick. A sort on the saved list will provide the result you were looking for... and the field you ultimately want saved { SOME_KEY } is extractable from FANCY_ITYPE. Bring on the flames... _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users