The percent (%) wildcard character can be used in parameters that allow wildcard-character search patterns. This wildcard character represents any string of zero or more characters.
If the percent (%) character is used in parameters that do not allow wildcard-character search patterns, the DB2 access service rejects the character and issues an error message.
Table 11-2 shows some examples of the percent (%) wildcard character and its use.
Sample string |
Matches |
|---|---|
%A% |
All names that contain the letter “A”; for example, A, AT, CAT |
% |
All names |
