ODBC Connector Options

Options

• checks

• data types

• date as timestamp

• default locking

• entity names

• field name size

• hold statements

• identifiers

• identifier case

• identifier quote char

• key syntax

• logon timeout

• mapping

• non null columns

• open statements

• record size

• step size

• table name size

• time as timestamp

Description

Most connector options are enable options; a specific feature is enabled by setting the option. Some options have a numeric parameter (a nonnegative decimal integer). Each numeric option has a default value, although the range of valid values is option-specific.

Syntax Rules

The syntax rules for USYS$ODx_PARAMS are:

• Each option may be specified only once

• Multiple options must be separated by commas (,)

• For specifying multiple options, you can use the short format

• Words and numbers within each option are separated by one or more spaces or tabs

• Options are not case-dependent

• All options have the form Directive=Value. Instead of the equal sign (=), a colon can be used. For example:

  USYS$OD0_PARAMS = step : 20, default locking = O

ODBCCONF Settings and ODBC Options

The previous ODBC Connector had a configuration tool called ODBCCONF, which has been replaced by new configuration utilities uodbccfg.exe (for version U4.0) and uodbccfg41.exe (for version U4.1). The following tables show the old ODBCCONF settings and their equivalent ODBC options in the Uniface ODBC Connector.