Attribute

ConfigOptions (CO)

Purpose

Determines how the mapping of the native data model to the relational data model is configured, customized, and updated.

Notes

  • This option is primarily used for initial configuration of the driver for a particular user. It is not intended for use with every connection. By default, the driver configures itself and this option is normally not needed. If Config Options is specified on a connection after the initial configuration, the values specified for Config Options must match the values specified for the initial configuration.

Valid Values

{ key = value [; key = value ]}

where:

key
is one of the following values:
  • columnDiscoverySampleSize
  • DefaultVarcharSize
  • KeywordConflictSuffix
  • LeadingUnderscoreReplacement
  • MaxVarcharSize
  • MinVarcharSize
  • SchemaFilter
  • UppercaseIdentifiers

The value is a set of key value pairs separated by a semicolon (;). The value must be enclosed in curly brackets. For example:

{columnDiscoverySampleSize=2000;DefaultVarcharSize=2x;KeywordConflictSuffix=TAB;LeadingUnderscoreReplacement=XX;MaxVarcharSize=5000;
MinVarcharSize=500;SchemaFilter=oem_sales:november;UppercaseIdentifiers=false}

See the following sections for description of these options and their values.

Default

{columnDiscoverySampleSize=1000;DefaultVarcharSize=1.5x;KeywordConflictSuffix=;LeadingUnderscoreReplacement=_;MaxVarcharSize=4000;
MinVarcharSize=255;SchemaFilter=;UppercaseIdentifiers=true}

GUI Tab

Advanced tab