Using an asterisk (*) or a pattern in entry fields

For entry fields on FM/Db2 panels where you can enter an asterisk (*) or wildcards, you can use:
  • An asterisk (*) on its own to match all values, or
  • A pattern using wildcard characters to select all objects that match the pattern.

In either case, FM/Db2 displays a selection list. To select the listed item you want, type S against the required entry and press Enter.

You can specify a pattern using the following characters:
asterisk (*) in combination with one or more other wildcard characters
Represents a string of zero or more characters. Acts the same as a percent sign (%).
percent sign (%)
Represents a string of zero or more characters. Acts the same as an asterisk (*).
underscore (_)
Represents any single character, including a trailing blank.
Other characters
Any other characters that are valid for the entry field.
The following examples show how various patterns work if used to select entries from the following list:
  • AGE
  • AGREE
  • GUM
  • IGLOO
  • MAN
  • MANE
  • MANY
  • MANAGE
  • MANAGES
Pattern
Entries selected
*AGE*
AGE, MANAGE, and MANAGES
MAN_
MAN, MANE, and MANY
MANAGE%
MANAGE and MANAGES
_G*
AGE, AGREE, and IGLOO
%G__
AGE, MANAGE, and MANAGES