Specifies whether the underscore character '_' is treated as a
wildcard.
- db2cli.ini keyword syntax:
- Underscore = 0 | 1
- Default setting:
- The underscore character matches any single character or no character.
- Usage notes:
-
This keyword specifies if the underscore character '_' will be
recognized as a wildcard or only as the underscore character. The possible
settings are as follows:
- 0 - The underscore character is treated only as the underscore character.
- 1 - The underscore character is treated as a wildcard that matches any
single character, including no character.
Setting Underscore to 0 can improve performance when there are database
objects with names that contain underscores.
This keyword applies only to the following catalog functions that
accept search patterns as arguments:
- SQLColumnPrivileges()
- SQLColumns()
- SQLProcedureColumns()
- SQLProcedures()
- SQLTablePrivileges()
- SQLTables()
Note that catalog functions may only accept search patterns on particular
arguments. Refer to the documentation of the specific function for details.