skip to main content
Connection Option Descriptions : Config Options
  

Try DataDirect Drivers Now

Config Options

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
* columnDiscoverySampleSize (Config Option)
* DefaultVarcharSize (Config Option)
* KeywordConflictSuffix (Config Option)
* LeadingUnderscoreReplacement (Config Option)
* MaxVarcharSize (Config Option)
* MinVarcharSize (Config Option)
* SchemaFilter (Config Option)
* UppercaseIdentifiers (Config Option)