HashFileLookup

[sridharvg]

Hi,

I would like to use the UtilityHashLookup for comparing the source value with the value coming from the Hashfile, but getting errors.
The code I modified is :
Locate HashTable in FilesOpened Setting POS Then
If Hashkey >=(Read Rec From FileHandles(POS), HashKey) Then
Ans = 'True'
End Else
Ans = DSRMessage("DSTAGE_TRX_I_0010" , "**RECORD NOT FOUND**", "" )
End
End Else
Requirement example: If the value coming from source is 6 and the lookup value is 5 in Hashfile, then I should get Ans='True'.

[ray.wurlod]

Not possible using a Hashed File stage or UtilityHashLookup(). These only do exact match, employing the hashing algorithm to do so in the most speedy fashion available.

What you seek to do is possible, but slow, using a UniVerse stage or BCI code (with no licensing issues) to refer to the hashed file. You may need to create a VOC pointer to the hashed file, if the hashed file was created in a directory.