skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The DB2 Wire Protocol Driver : Connection Option Descriptions : Use Current Schema for Catalog Functions
  
Use Current Schema for Catalog Functions
Attribute
UseCurrentSchema (UCS)
Purpose
Specifies whether results are restricted to the tables and views in the current schema if a catalog function call is made without specifying a schema or if the schema is specified as the wildcard character %. Restricting results to the tables and views in the current schema improves performance of catalog calls that do not specify a schema.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), results of catalog function calls are restricted to the tables and views in the current schema.
If set to 0 (Disabled), results of catalog function calls are not restricted.
Default
0 (Disabled)
GUI Tab
Advanced tab