Populations and Controls

Populations and Controls

Exact Matching

Exact Matching

The exact matching returns 100% score if the search data values match with the file data values. You can perform exact matching on any data type.
Use the following format to perform exact matching:
PURPOSE=<Purpose Name> SEARCH=<Field Name>[(<Field ID>;<Weight>;Exact[:B|Z|ZB])],<Offset>,<Length> FILE=[(<Field ID>;<Weight>;Exact)],<Offset>,<Length>
If you want to extend a key field, use any number as the
Field ID
value. If you do not want to extend any key field, use 0 as the
Field ID
value. If you extend a key field in the search or file data, you must extend the corresponding key field in the search or file data.
The value
B
indicates a null value, the value
Z
indicates a zero value, and the value
ZB
indicates a null or zero value.
The following sample expressions perform exact matching between the search data and file data values:
  • PURPOSE=Person_Name SEARCH=Person_Name(Exact),0,16 FILE=Person_Name,0,16
    . The expression returns 100% score only if the search data value exactly matches with the file data value.
  • PURPOSE=Fields SEARCH=Person_Name(2;5;Exact),0,16 FILE=Person_Name(2;Exact),0,16
    . The expression creates an extended field for the
    Person_Name
    field named
    Person_Name(2)
    and sets the weight for the extended field to 5. The search data value returns 100% score if the search data value exactly matches with the file data value.
  • PURPOSE=Person_Name SEARCH=Person_Name(0;5;Exact),0,16 FILE=Person_Name,0,16
    . The expression sets the weight of the
    Person_Name
    field to 5 without creating any extended field. The search data value returns 100% score if the search data value exactly matches with the file data value.
  • PURPOSE=Person_Name SEARCH=Person_Name(1;Exact),0,16 FILE=Person_Name(1;Exact),0,16
    . The expression creates an extended field for the
    Person_Name
    field named
    Person_Name(1)
    . The extended field uses the weight of the
    Person_Name
    field. The search data value returns 100% score if the search data value exactly matches with the file data value.
  • PURPOSE=Fields SEARCH=Date,0,8 FILE=Date(Exact:Z),0,8
    . The expression returns 100% score if the file data value is 0.

0 COMMENTS

We’d like to hear from you!