skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Oracle Wire Protocol Driver : Connection Option Descriptions : Catalog Options
  
Catalog Options
Attribute
CatalogOptions (CO)
Purpose
Determines whether SQL_NULL_DATA is returned for the result columns REMARKS and COLUMN_DEF.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the result column REMARKS (for the catalog functions SQLTables and SQLColumns) and the result column COLUMN_DEF (for the catalog function SQLColumns) return actual values. Enabling this option reduces the performance of your catalog (SQLColumns and SQLTables) queries.
If set to 0 (Disabled), SQL_NULL_DATA is returned for the result columns REMARKS and COLUMN_DEF.
Notes
*This connection option can affect performance.
Default
0 (Disabled)
GUI Tab
Advanced tab
See also
Performance Considerations