To Execute this Example
Use process SET_182 and choose option OPNQRYF wildcard search. Specify a text string to search for in the employee surname, and press Enter.
Here are some %WLDCRD examples:
QRYSLT(‘SURNAME *EQ %WLDCRD(“H__BA*”)’)
This means: The name must begin with character H. The second and third characters are unimportant (both are underscores), character four and five must contain the characters BA, the rest (this is the *) is unimportant.
QRYSLT(‘SURNAME *EQ %WLDCRD(“H*A*”)’)
This means: The first characters must be an H and somewhere in the name their must be a character A (this is the *A*).
| Wild Card Searching Using OPNQRYF | The Things that Make Up this Example |
Use process SET_182 and choose option OPNQRYF wildcard search. Specify a text string to search for in the employee surname, and press Enter.
Here are some %WLDCRD examples:
QRYSLT(‘SURNAME *EQ %WLDCRD(“H__BA*”)’)
This means: The name must begin with character H. The second and third characters are unimportant (both are underscores), character four and five must contain the characters BA, the rest (this is the *) is unimportant.
QRYSLT(‘SURNAME *EQ %WLDCRD(“H*A*”)’)
This means: The first characters must be an H and somewhere in the name their must be a character A (this is the *A*).