dick scherrer wrote:To repeat - JOINKEYS must have data in sorted order. . . It does not provide a random file search.
May be I misunderstood your comment here. But JOINKEYS does n't need the input data to be in sorted order of the key. But the JOIN operation does sort both the input files on the key mentioned in the JOINKEYS statement before doing a file-match.
dick scherrer wrote:Actually, I am picking unique values from a file and trying to extract those values from some other huge file
Is your 'huge file' sorted on any field? Please provide the details requested here.