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

Reply via email to