DSNIELIK

Module DSNIELIK evaluates a LIKE Predicate. It applies the mask of the LIKE predicate to the column being evaluated. This module will be used heavily during SCANS of data to qualify rows based upon the LIKE predicate.

Hints

The LIKE predicate is indexable in the form :HOSTVAR when the host variable is an indexable constant and a field procedure does not exist on the column. For example, :HV = 'char%'.

The length of the host variable does not need to match the length of the column for the predicate to be indexable. In fact, effectively padding the host variable with blanks (for example: 'char% ') may not produce the desired result set. Instead, define the host variable with only the significant length.

Reference Sources

IBM Db2 for OS/390, Messages and Codes, GC26-8979

IBM Db2 for OS/390, Application Programming and SQL Guide, SC26-8958

IBM Db2 for OS/390, Installation Guide, GC26-8970