Windows Registry Information › Registry Information › HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI › Data Source Advanced Options › Values

Values

AccessibleTables=0|1

When set to 1, the ODBC and JDBC drivers use the SYSCA.ACCESSIBLE_TABLES view, or another view defined by you, for the SQLTables function and getTables method. A setting of 0 disables this option. This value is set from the Use Accessible Tables View Name field.

AccountPrompt=0|1

Directs the ODBC driver to prompt for information if the ACCT keyword is not supplied in the connection string passed to SQLDriverConnect. For more information, see the appendix "Passing Accounting Information to CA IDMS."

CacheSQLTables=0|1

When set to 1, the ODBC driver caches the table list returned from an SQLTables call. A value of 0 disables this option. This value is set from the Cache SQL Tables option.

CallSelect=0|1

A value of 1 specifies that the ODBC and JDBC drivers should treat all SQL CALL statements as SELECT statements. This means that all parameters are returned in a result set. All procedures are essentially treated as TABLE PROCEDUREs, which can be useful to solve compatibility problems with some applications. The default is 0, which allows the use of the CallableStatement methods with an SQL CALL statement. This feature is deprecated and should not be used with new applications.

CatalogTable=view_name

Specifies the name of the view that the ODBC and JDBC drivers use for the SQLTables function and getTables method, if other than the default view name. This value is set from the Use Accessible Tables View Name field.

CloseCommit=0|1 (ODBC Driver)

When enabled, CA IDMS Server sends a COMMIT following a CLOSE when auto-commit is off. The default value is 1, enabled. This option is also considered enabled when auto-commit is on. The COMMIT (or COMMIT CONTINUE) is usually piggybacked onto the FETCH or CLOSE request when no other cursors are open and no updates are pending. This can also be specified in a specific Data Source section.

Default value: 1 (enabled)

CloseCommit=0|1 (JDBC Driver)

When enabled, CA IDMS Server sends a COMMIT following a CLOSE operation. The default value is 0, disabled. This option is only in affect when auto-commit is on. The COMMIT (or COMMIT CONTINUE) is usually piggybacked onto the FETCH or CLOSE request when no other cursors are open and no updates are pending. This option can also be specified in a specific Data Source section.

Default value: 0 (disabled)

CommitBehavior=0|1|2

Specifies the way a COMMIT operation affects cursors in CA IDMS. This also determines the value returned by the ODBC SQLGetInfo function for the SQL_CURSOR_COMMIT_BEHAVIOR option and the JDBC default ResultSetHoldability. This value is set from the Commit Behavior field. Values are:

• 0—Specifies SQL_CB_DELETE, which is equivalent to ResultSet.CLOSE_CURSORS_AT_COMMIT. All open cursors are closed, and all prepared statements are deleted. Specified by selecting Close and Delete Cursors in the Commit Behavior field.
• 1—Specifies SQL_CB_CLOSE, which is equivalent to ResultSet.CLOSE_CURSORS_AT_COMMIT. All open cursors are closed, but prepared statements are not deleted. Specified by selecting Close Cursors in the Commit Behavior field.
• 2—Specifies SQL_CB_PRESERVE, which is equivalent to ResultSet.HOLD_CURSORS_OVER_COMMIT. All cursors remain open, and their position is preserved. Prepared statements are not deleted. Specified by selecting Preserve Cursors in the Commit Behavior field.

CommitSuspend=0|1

Causes the driver to issue a SUSPEND after each COMMIT. The default is 1, enabled. SuspendStrategy should generally be used instead of this option. The SuspendStrategy must be set to 3 (CUSTOM) to use this option.

ConnectSuspend=0|1

Causes the JDBC driver to issue a SUSPEND and end the task immediately after it establishes a connection. ODBC does not provide a way for the driver to be notified of this event. The default for a pooled connection is 1, otherwise it is 0. SuspendStrategy should generally be used instead of this option. The SuspendStrategy must be set to 3 (CUSTOM) to use this option.

DefaultParmType=integer_value

Specifies an ODBC SQL data type, as defined in the ODBC sql.h header file, that is used as the default type when an ODBC function requiring the SQL statement to be prepared is executed before all input parameters are bound. Recommended values are:

• 1—SQL_CHAR
• 4—SQL_INTEGER
• 5—SQL_SMALLINT

This feature is deprecated, CA IDMS and the drivers support DESCRIBE INPUT.

DefaultSchema=schema_name

Specifies the name of the default SQL Schema. This is an optional 1-to-18 character field. When specified, this field is used as the schema qualifier for all SQL table references that to do not contain an explicit schema qualifier. The default is blank (unspecified)

DescribeExtended=0|1

When set to 1, the driver requests extended column descriptor information from a CA IDMS r17 system, including the names of the schema and table. The default for CA IDMS r17 SP0 is 0, for r17 SP1 it is 1. This is ignored for prior releases.

EnableEnsure=0|1

When set to 1, the ODBC driver honors the ENSURE parameter of the SQLStatistics function call. A setting of 0 disables this option. This value is set from the Enable Ensure field.

FetchDouble=0|1

When set to 1, CA IDMS converts single precision floating point numbers to double precision floating point before returning them to CA IDMS Server. This value is set from the Fetch Real as Double field.

FetchRows=integer_value

Specifies the number of database rows CA IDMS Server fetches at a time. The default is 0, which causes the driver to request the number of rows that fits in a fetch buffer of the size specified by the FetchSize registry. This value is set from the Fetch Row Count field.

FetchSize=integer_value

Specifies the maximum size that the JDBC driver attempts to use for a FETCH buffer. The default is 64,000 when using the IDMS native TCP/IP interface. The default and maximum is 29,000 when using CAICCI/PC. This should generally be left at the default setting. This value is set from the Fetch Row Size field.

FetchSuspend=0|1

When enabled, CA IDMS Server causes a SUSPEND to be piggybacked onto each BULK FETCH, ending the IDMS-DC task. The default is 0, disabled. SuspendStrategy should generally be used instead of this option. The SuspendStrategy must be set to 3 (CUSTOM) to use this option.

FetchSuspendClose=0|1

In prior releases caused a conditional SUSPEND to be piggybacked onto each FETCH. The SUSPEND was done only if the cursor reached the end. This option is no longer supported; the CloseCommit and CommitSuspend options specify the equivalent behavior.

IgnoreDTC=0|1

A value of 1 specifies that the CA IDMS Server ODBC driver ignores requests for distributed transactions with Microsoft's Distributed Transaction Coordinator (DTC). This option should normally be set to 0.

InvalidDecimal=0|1|2|3

Specifies how the ODBC and JDBC drivers handle invalid packed or zoned decimal data returned in a result set column. This value is set from the invalid Decimal Action field. Options are:

• 0—Return error, the default
• 1—Return NULL
• 2—Return 0
• 3—Ignore, ODBC only

LoginTimeout=integer_value

Specifies the system loginTimeout used when the JDBC DriverManager or DataSource setLoginTimeout is set to 0.

PoolSuspendActive=0|1

In prior releases caused a pooled connection to be treated like a non-pooled connection. This is no longer supported, the CommitSuspend option specifies the equivalent behavior.

PreservePrepared=0|1

Attempt to preserve prepared statements when the ODBC cursor commit behavior is preserve or JDBC result set holdability is enabled. The default is 0, disabled, which maximizes concurrency between transactions. The CA IDMS SQL statement caching feature can be used to minimize the overhead of re-preparing statements.

QueryTimeout

Specifies the default reply timeout for SQL requests which use a Java Statement object when using the JDBC driver.

ReadOnly=0|1

Specifies the default access mode for the ODBC and JDBC drivers. A setting of 0 specifies Read Write. A setting of 1 specifies Read Only. This value is set from the Access Mode field.

SuspendStrategy=0|1|2|3

Specifies how the driver uses pseudo-conversational processing. This value is set from the Suspend Strategy field, and is equivalent to specifying the detailed suspend options, as described in Chapter 3, "Setting Up Your CA IDMS System." Values are:

• 0—INTERACTIVE, the default.
• 1—SERVICE, suspend when idle.
• 2—BATCH, never suspend.
• 3—CUSTOM, defined by the detailed options.

TxnIsolation=1|2

Specifies the degree to which your transactions impact, and are impacted by, other users accessing the same data. A setting of 1 specifies Read Uncommitted, 2 specifies the default setting, Read Committed. This value is set from the Transaction Isolation field.

WaitTimeOut

Specifies the default system reply timeout for the JDBC driver.