Underscore CLI/ODBC and IBM data server driver configuration keyword

Specifies whether the underscore character '_' is treated as a wildcard.

db2cli.ini keyword syntax:
Underscore = 0 | 1
IBM data server driver configuration file (db2dsdriver.cfg) syntax:
<parameter name="Underscore" value="0 | 1"/>
Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
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.