Very Good morning to everyone on this list, I am having 3 seperate Suprtool extracted SD files with record layouts as mentioned below : >FO AI85OS01 File: AI85OS01.BCDATA.AIHWORK (SD Version B.00.00) Entry: Offset MEMBERS X9 1 GROUP# X6 10 DIVISION# X10 16 MARITALSTAT X2 26 REGION X2 28 YMDEFF X8 30 YMDEND X8 38 AFF# X16 46 Limit: 25000 EOF: 25000 Entry Length: 61 Blocking: 67 >FO AI85OS05 File: AI85OS05.BCDATA.AIHWORK (SD Version B.00.00) Entry: Offset ALTPOLICY# X16 1 MEMBERS X9 17 <<Sort# 1 >> Limit: 1744 EOF: 1744 Entry Length: 25 Blocking: 133 >FO AI85OS06 File: AI85OS06.BCDATA.AIHWORK (SD Version B.00.00) Entry: Offset ALTPOLICY# X16 1 <<Sort# 1 >> COV-ARRAY X20 17 BEGDATE X8 37 <<YYYYMMDD>> ENDDATE X8 45 <<YYYYMMDD>> Limit: 1209 EOF: 1209 Entry Length: 52 Blocking: 64 > The above snapshot of number of records in each S01, S05 and S06 files are just in a test condition and the actual files are having close to 6500000, 550000 and 400000 records respectively. The above S01 file contains records under Member-Span, S05 contains records of Unique Altpolicy# and the corresponding Member numbers associated with it and S06 file contains the detail of Altpolicy-Span records. I would like to scan each Altpolicy-Span records from S06 file and determine the corresponding Member-Span records associated with it. The additional condition which I need to have here is that the Member-Spans should be effective for Altpolicy-span records based on the date. i.e. (YMDEFF >= BEGDATE) or (YMDEND <= ENDDATE) or (BEGDATE >= YMDEFF and ENDDATE <= YMDEND). How can I accomplish this in files containing big big records ? Is there any possiblity through LINK or SUPRLINK that I can have this done ? Any one experienced a shortcut solution for these kind of situations before ? I know I can get this done in a step by step analysis by going through each of those files and then doing a Lookup and getting what I need, but I think that is going to be more time consuming and I feel there could be a better way !! Any pointers, helps, questions, queries, etc are more than welcome in this direction. Thanks in advance. Raghu. ----------------------------------------------------------- Get free personalized email at http://www.infospacemail.com