The following advanced options reside under the Data Source Name (DSN) sub-key. Note that integer values be stored as a registry type of REG SZ when set under a data source name sub-key in the registry. Commonly used options are set in the CA IDMS Server ODBC Administrator Data Source tab Advanced Options dialog. Rarely used options can be set by editing the registry.
|
Value Name |
Value |
|---|---|
|
AccessibleTables |
0|1 |
|
AccountPrompt |
0|1 |
|
CacheSQLTables |
0|1 |
|
CatalogTable |
view_name |
|
CallSelect |
0|1 |
|
CloseCommit |
0|1 (ODBC Driver) |
|
CloseCommit |
0|1 (JDBC Driver) |
|
CommitBehavior |
0|1|2 |
|
ConnectSuspend |
0|1 |
|
DefaultParmType |
integer_value |
|
DefaultSchema |
schema_name |
|
DescribeExtended |
0|1 |
|
EnableEnsure |
0|1 |
|
FetchDouble |
0|1 |
|
FetchRows |
integer_value |
|
FetchSize |
integer_value |
|
FetchSuspend |
0|1 |
|
FetchSuspendClose |
0|1 |
|
IgnoreDTC |
0|1 |
|
InvalidDecimal |
integer_value |
|
LoginTimeout |
integer_value |
|
PoolSuspendActive |
0|1 |
|
PreservePrepared |
0|1 |
|
QueryTimeout |
integer_value |
|
ReadOnly |
0|1 |
|
SuspendStrategy |
0|1|2|3 |
|
TxnIsolation |
1|2 |
|
WaitTimeOut |
integer_value |
|
Copyright © 2009 CA.
All rights reserved.
|
|