This filter uses OPNQRYF feature on AS/400.
Filters on composite keys.
To build the composite key value, use function HBuildKeyValue.
Use constant keywords hMinVal and hMaxVal to complete key
values.
Following example filters all customers having name beginning with "Dupond" :
HFilter(Clients,Name,
HBuildKeyValue(Clients, Name, "Dupond")+hMinVal, ...
HBuildKeyValue(Clients, Name, "Dupond")+hMaxVal)
Sequence of sorting
Be careful, if the heading uses a sequence of sorting in which the last character is not the code "FF", see the option HFMAXKEY extended information of the Connection.