Configuration File Information › Configuration Information › Sections › Datasource

Datasource

The [datasource_name] section identifies CA IDMS databases, and can be specified in the JDBC URL or the IdmsDataSource databaseName property. A datasource_name section may contain the following key-values:

AccessibleTables=0|1

Enables the use of an alternate view for the getTables method. The default is 1, a setting of 0 disables this option. The view name is specified with the CatalogTable key.

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 JDBC driver uses for the getTables method, when AccessibleTables=1. If not specified the driver uses the SYSCA.ACCESSIBLE_TABLES view.

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 effect 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|2

Specifies the default as ResultSetHoldability, which is the way a COMMIT operation affects cursors in CA IDMS. The values set in the configuration file map to the JDBC ResultSet values as follows:

• 0—ResultSet.CLOSE_CURSORS_AT_COMMIT. All open cursors are closed and all prepared statements are deleted (although the SQL statement is cached in the Statement object and prepared again if needed).
• 2—ResultSet.HOLD_CURSORS_OVER_COMMIT. All cursors remain open and their position is preserved. Prepared statements are not deleted

These values are consistent with those used to the set SQL_CURSOR_COMMIT_BEHAVIOR for ODBC (on Windows the ODBC and JDBC drivers use the same option in the registry). The JDBC driver interprets a value of 1 as 0.

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. Only when the SuspendStrategy is set (or defaults) to “Custom” will the CommitSuspend option be in effect.

ConnectSuspend=0|1

Causes the JDBC driver to issue a SUSPEND and end the task immediately after it establishes a connection. The default for a pooled connection is 1, otherwise it is 0. SuspendStrategy should generally be used instead of this option. Only when the SuspendStrategy is set (or defaults) to “Custom” will the ConnectSuspend option be in effect.

Dictionary=dict_name

Specifies the name of the dictionary containing the SQL schema definitions for the tables or network records to be accessed. This name is defined in the DBNAME table on the target CA IDMS system. The default value is the first eight characters of the datasource_name.

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 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.

FetchRows=integer_value

Specifies the default value for the JDBC statement object fetchSize property. This is the number of rows that the JDBC driver requests from CA IDMS for each BULK FETCH. The value can be set and queried at run time using the JDBC setFetchSize and getFetchSize methods. When set to 0, the default, the JDBC driver attempts to fetch as many rows as will fit in a buffer of size specified by the FetchSize option.

Note: The name of this option in the configuration file does not correspond exactly to the JDBC object properties in order to remain compatible with previous versions of CA IDMS Server.

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. Only when the SuspendStrategy is set (or defaults) to “Custom” will the FetchSuspend option be in effect.

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 is no longer supported; the CloseCommit and CommitSuspend options specify the equivalent behavior.

InvalidDecimal=0|1|2

Specifies how the JDBC driver is to handle invalid packed or zoned decimal data returned in a result set column. Options are as follows:

0—Return error. This is the default setting

1—Return NULL

2—Return 0

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 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=integer_value

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 JDBC driver. A setting of 0 specifies Read Write. A setting of 1 specifies Read Only.

Server=server_name

(Required) Specify the CV used to access the data. This name can be a NODE Name or a user-defined Server name, referring to a Server server_name section containing additional connection information.

A datasource_name section can also contain database specific options, described in the Options section. Default values that apply to all data sources can be set in the Options section.

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 as follows:

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.

WaitTimeOut=integer_value

Specifies the default system reply timeout for the JDBC driver.