DB2 Version 9.7 for Linux, UNIX, and Windows

Underscore CLI/ODBC configuration keyword

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.