skip to main content
DataDirect Connect Drivers : DB2 Driver : Connection Properties : CatalogOptions
  
CatalogOptions
Purpose
Determines which type of metadata information is included in result sets when an application calls DatabaseMetaData methods.
Valid Values
0 | 2 | 6
Behavior
If set to 0, result sets do not contain synonyms or remarks.
If set to 2, result sets contain synonyms and remarks that are returned from the following DatabaseMetaData methods: getColumns(), getExportedKeys(), getFunctionColumns(), getFunctions(), getImportedKeys(), getIndexInfo(), getPrimaryKeys(), getProcedureColumns(), and getProcedures().
If set to 6, a hint is provided to the driver to emulate getColumns() calls using the ResultSetMetaData object instead of querying database catalogs for column information. Result sets contain synonyms, but not remarks. Using emulation can improve performance because the SQL statement that is formulated by the emulation is less complex than the SQL statement that is formulated using getColumns(). The argument to getColumns() must evaluate to a single table. If it does not, because of a wildcard or null value, for example, the driver reverts to the default behavior for getColumns() calls.
Default
2
Data Type
int
See also
Performance Considerations