skip to main content
Connection Option Descriptions : Catalog Mode
  

Try DataDirect Drivers Now

Catalog Mode

Attribute

CatalogMode (CM)

Purpose

Specifies whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions.

Valid Values

0 | 1 | 2

Behavior

If set to 0 (Mixed), the driver uses a combination of ODBC catalog functions and driver-discovered information to retrieve catalog information. Select this option for the optimal balance of performance and accuracy.
Note: In this setting, the driver uses the best techniques for retrieving information. These techniques vary depending on the server used, which may result in differences in performance.
If set to 1 (Native), the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions. This setting provides the best performance, but at the expense of less-accurate catalog information.
If set to 2 (Query Based), the driver uses driver-discovered information to retrieve catalog information. This option provides highly accurate catalog information, but at the expense of slower performance.

Default

0 (Mixed)

GUI Tab

Advanced tab

See Also

*Performance Considerations