LIKE_BLANK_INSIGNIFICANT in macro DSN6SPRM
LIKE_BLANK_INSIGNIFICANT subsystem parameter specifies whether blanks are significant when applying the LIKE predicate to a string. If set, the blank insignificant behavior applies.
| Acceptable values: | NO, YES |
|---|---|
| Default: | NO |
| DSNZPxxx: | DSN6SPRM.LIKE_BLANK_INSIGNIFICANT |
- NO
- LIKE treats trailing blanks within fixed-length character strings as significant.
- YES
- When the LIKE predicate is applied against fixed-length character column data, Db2 strips trailing blanks from the data before performing the comparison. If the data is all blank, Db2 reduces it to a single blank before performing the comparison.