skip to main content
Connection Property Descriptions : ConfigOptions
  

Try DataDirect Drivers Now

ConfigOptions

Purpose

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

Notes

*This property 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 property is normally not needed. Alternatively, you can specify values for configuration options when creating a schema map with the Schema Tool. Specifically, in the Open Schema Map dialog, you can indicate values using the key=value convention in the Configuration Options field.
*If ConfigOptions is specified on a connection after the initial configuration, the values specified for ConfigOptions must match the values specified for the initial configuration.

Valid Values

( key = value [; key = value ])
where:
key
is one of the following configuration options:
*ColumnDiscoverySampleSize
*DefaultVarcharSize
*KeywordConflictSuffix
*LeadingUnderscoreReplacement
*MaxVarcharSize
*MinVarcharSize
*SchemaFilter
*UppercaseIdentifiers
value
specifies a setting for the configuration option.
When specifying configuration options in a connection string, key value pairs must be enclosed in parentheses and separated by a semicolon. For example:
ConfigOptions=(ColumnDiscoverySampleSize=2000;DefaultVarcharSize=2x;
KeywordConflictSuffix=TAB;LeadingUnderscoreReplacement=XX;MaxVarcharSize=5000;
MinVarcharSize=500;SchemaFilter=oem_sales:november;UppercaseIdentifiers=false)

Default

ColumnDiscoverySampleSize=1000;
DefaultVarcharSize=1.5x;
KeywordConflictSuffix=;
LeadingUnderscoreReplacement=;
MaxVarcharSize=4000;
MinVarcharSize=255;
SchemaFilter=;
UppercaseIdentifiers=true

Data Type

String
* ColumnDiscoverySampleSize (Configuration Option)
* DefaultVarcharSize (Configuration Option)
* KeywordConflictSuffix (Configuration Option)
* LeadingUnderscoreReplacement (Configuration Option)
* MaxVarcharSize (Configuration Option)
* MinVarcharSize (Configuration Option)
* SchemaFilter (Configuration Option)
* UppercaseIdentifiers (Configuration Option)