IBM OLE DB Provider support for OLE DB properties
The following table shows the OLE DB properties that are supported by the IBM® OLE DB Provider for Db2®:
| Properties | Default Value | R/W |
|---|---|---|
| DBPROP_MULTIPLECONNECTIONS | VARIANT_FALSE | R |
| DBPROP_RESETDATASOURCE | DBPROPVAL_RD_RESETALL | R/W |
| Properties | Default Value | R/W |
|---|---|---|
| DB2PROP_REPORTISLONGFORLONGTYPES | VARIANT_FALSE | R/W |
| DB2PROP_RETURNCHARASWCHAR | VARIANT_TRUE | R/W |
| DB2PROP_SORTBYORDINAL | VARIANT_FALSE | R/W |
| Properties | Default Value | R/W |
|---|---|---|
|
DBPROP_ACTIVESESSIONS
|
0 |
R
|
| DBPROP_ASYNCTXNABORT | VARIANT_FALSE | R |
| DBPROP_ASYNCTXNCOMMIT | VARIANT_FALSE | R |
| DBPROP_BYREFACCESSORS | VARIANT_FALSE | R |
| DBPROP_COLUMNDEFINITION | DBPROPVAL_CD_NOTNULL | R |
| DBPROP_CONCATNULLBEHAVIOR | DBPROPVAL_CB_NULL | R |
| DBPROP_CONNECTIONSTATUS | DBPROPVAL_CS_INITIALIZED | R |
| DBPROP_DATASOURCENAME | N/A | R |
| DBPROP_DATASOURCEREADONLY | VARIANT_FALSE | R |
| DBPROP_DBMSNAME | N/A | R |
| DBPROP_DBMSVER | N/A | R |
| DBPROP_DSOTHREADMODEL | DBPROPVAL_RT_FREETHREAD | R |
| DBPROP_GROUPBY | DBPROPVAL_GB_CONTAINS_SELECT | R |
| DBPROP_IDENTIFIERCASE | DBPROPVAL_IC_UPPER | R |
| DBPROP_MAXINDEXSIZE | 0 | R |
| DBPROP_MAXROWSIZE | 0 | R |
| DBPROP_MAXROWSIZEINCLUDESBLOB | VARIANT_TRUE | R |
| DBPROP_MAXTABLEINSELECT | 0 | R |
| DBPROP_MULTIPLEPARAMSETS | VARIANT_FALSE | R |
| DBPROP_MULTIPLERESULTS | DBPROPVAL_MR_SUPPORTED | R |
| DBPROP_MULTIPLESTORAGEOBJECTS | VARIANT_TRUE | R |
| DBPROP_MULTITABLEUPDATE | VARIANT_FALSE | R |
| DBPROP_NULLCOLLATION | DBPROPVAL_NC_LOW | R |
| DBPROP_OLEOBJECTS | DBPROPVAL_OO_BLOB | R |
| DBPROP_ORDERBYCOLUMNSINSELECT | VARIANT_FALSE | R |
|
DBPROP
_OUTPUTPARAMETERAVAILABILITY |
DBPROPVAL_OA_ATEXECUTE
|
R
|
| DBPROP_PERSISTENTIDTYPE | DBPROPVAL_PT_NAME | R |
| DBPROP_PREPAREABORTBEHAVIOR | DBPROPVAL_CB_DELETE | R |
| DBPROP_PROCEDURETERM | "STORED PROCEDURE" | R |
| DBPROP_PROVIDERFRIENDLYNAME | "IBM OLE DB Provider for Db2" | R |
| DBPROP_PROVIDERNAME | "IBMDADB2.DLL" | R |
| DBPROP_PROVIDEROLEDBVER | "02.7" | R |
| DBPROP_PROVIDERVER | N/A | R |
| DBPROP_QUOTEIDENTIFIERCASE | DBPROPVAL_IC_SENSITIVE | R |
|
DBPROP
_ROWSETCONVERSIONSONCOMMAND |
VARIANT_TRUE
|
R
|
| DBPROP_SCHEMATERM | "SCHEMA" | R |
|
DBPROP_SCHEMAUSAGE
|
DBPROPVAL_SU_DML_STATEMENTS |
DBPROPVAL_SU_TABLE_DEFINITION | DBPROPVAL_SU_INDEX_DEFINITION | DBPROPVAL_SU_PRIVILEGE_DEFINITION |
R
|
|
DBPROP_SQLSUPPORT
|
DBPROPVAL_SQL_ODBC_EXTENDED |
DBPROPVAL_SQL_ESCAPECLAUSES | DBPROPVAL_SQL_ANSI92_ENTRY |
R
|
| DBPROP_SERVERNAME | N/A | R |
| DBPROP_STRUCTUREDSTORAGE | DBPROPVAL_SS_ISEQUENTIALSTREAM | R |
|
DBPROP_SUBQUERIES
|
DBPROPVAL_SQ_CORRELATEDSUBQUERIES |
DBPROPVAL_SQ_COMPARISON | DBPROPVAL_SQ_EXISTS | DBPROPVAL_SQ_IN | DBPROPVAL_SQ_QUANTIFIED | |
R
|
| DBPROP_SUPPORTEDTXNDDL | DBPROPVAL_TC_ALL | R |
|
DBPROP_SUPPORTEDTXNISOLEVELS
|
DBPROPVAL_TI_CURSORSTABILITY |
DBPROPVAL_TI_READCOMMITTED | DBPROPVAL_TI_READUNCOMMITTED | DBPROPVAL_TI_SERIALIZABLE | |
R
|
|
DBPROP_SUPPORTEDTXNISORETAIN
|
DBPROPVAL_TR_COMMIT_DC |
DBPROPVAL_TR_ABORT_NO | |
R
|
| DBPROP_TABLETERM | "TABLE" | R |
| DBPROP_USERNAME | N/A | R |
| Properties | Default Value | R/W |
|---|---|---|
| DBPROP_AUTH_PASSWORD | N/A | R/W |
| DBPROP_INIT_TIMEOUT (1) | 0 | R/W |
|
DBPROP_AUTH_PERSIST
_SENSITIVE_AUTHINFO |
VARIANT_FALSE | R/W |
| DBPROP_AUTH_USERID | N/A | R/W |
| DBPROP_INIT_DATASOURCE | N/A | R/W |
| DBPROP_INIT_HWND | N/A | R/W |
| DBPROP_INIT_MODE | DB_MODE_READWRITE | R/W |
| DBPROP_INIT_OLEDBSERVICES | 0xFFFFFFFF | R/W |
| DBPROP_INIT_PROMPT | DBPROMPT_NOPROMPT | R/W |
| DBPROP_INIT_PROVIDERSTRING | N/A | R/W |
| Properties | Default Value | R/W |
|---|---|---|
| DBPROP_ABORTPRESERVE | VARIANT_FALSE | R |
| DBPROP_ACCESSORDER | DBPROPVAL_AO_RANDOM | R |
| DBPROP_BLOCKINGSTORAGEOBJECTS | VARIANT_FALSE | R |
| DBPROP_BOOKMARKS | VARIANT_FALSE | R/W |
| DBPROP_BOOKMARKSKIPPED | VARIANT_FALSE | R |
| DBPROP_BOOKMARKTYPE | DBPROPVAL_BMK_NUMERIC | R |
| DBPROP_CACHEDEFERRED | VARIANT_FALSE | R/W |
| DBPROP_CANFETCHBACKWARDS | VARIANT_FALSE | R/W |
| DBPROP_CANHOLDROWS | VARIANT_FALSE | R |
| DBPROP_CANSCROLLBACKWARDS | VARIANT_FALSE | R/W |
| DBPROP_CHANGEINSERTEDROWS | VARIANT_FALSE | R |
| DBPROP_COMMITPRESERVE | VARIANT_TRUE | R/W |
| DBPROP_COMMANDTIMEOUT | 0 | R/W |
| DBPROP_DEFERRED | VARIANT_FALSE | R |
| DBPROP_IAccessor | VARIANT_TRUE | R |
| DBPROP_IColumnsInfo | VARIANT_TRUE | R |
| DBPROP_IColumnsRowset | VARIANT_TRUE | R/W |
| DBPROP_IConvertType | VARIANT_TRUE | R |
| DBPROP_IMultipleResults | VARIANT_FALSE | R/W |
| DBPROP_IRowset | VARIANT_TRUE | R |
| DBPROP_IRowChange | VARIANT_FALSE | R/W |
| DBPROP_IRowsetFind | VARIANT_FALSE | R |
| DBPROP_IRowsetIdentity | VARIANT_TRUE | R |
| DBPROP_IRowsetInfo | VARIANT_TRUE | R |
| DBPROP_IRowsetLocate | VARIANT_FALSE | R/W |
| DBPROP_IRowsetScroll | VARIANT_FALSE | R/W |
| DBPROP_IRowsetUpdate | VARIANT_FALSE | R |
| DBPROP_ISequentialStream | VARIANT_TRUE | R |
| DBPROP_ISupportErrorInfo | VARIANT_TRUE | R |
| DBPROP_LITERALBOOKMARKS | VARIANT_FALSE | R |
| DBPROP_LITERALIDENTITY | VARIANT_TRUE | R |
| DBPROP_LOCKMODE | DBPROPVAL_LM_SINGLEROW | R/W |
| DBPROP_MAXOPENROWS | 32767 | R |
| DBPROP_MAXROWS | 0 | R/W |
| DBPROP_NOTIFICATIONGRANULARITY | DBPROPVAL_NT_SINGLEROW | R/W |
| DBPROP_NOTIFICATION PHASES |
DBPROPVAL_NP_OKTODO
DBPROPBAL_NP_ABOUTTODO DBPROPVAL_NP_SYNCHAFTER DBPROPVAL_NP_FAILEDTODO DBPROPVAL_NP_DIDEVENT |
R |
| DBPROP_NOTIFYROWSETRELEASE |
DBPROPVAL_NP_OKTODO
DBPROPVAL_NP_ABOUTTODO |
R |
|
DBPROP
_NOTIFYROWSETFETCHPOSITIONCHANGE |
DBPROPVAL_NP_OKTODO
DBPROPVAL_NP_ABOUTTODO |
R |
| DBPROP_NOTIFYCOLUMNSET |
DBPROPVAL_NP_OKTODO
DBPROPVAL_NP_ABOUTTODO |
R |
| DBPROP_NOTIFYROWDELETE |
DBPROPVAL_NP_OKTODO
DBPROPVAL_NP_ABOUTTODO |
R |
| DBPROP_NOTIFYROWINSERT |
DBPROPVAL_NP_OKTODO
DBPROPVAL_NP_ABOUTTODO |
R |
| DBPROP_ORDEREDBOOKMARKS | VARIANT_FALSE | R |
| DBPROP_OTHERINSERT | VARIANT_FALSE | R |
| DBPROP_OTHERUPDATEDELETE | VARIANT_FALSE | R/W |
| DBPROP_OWNINSERT | VARIANT_FALSE | R |
| DBPROP_OWNUPDATEDELETE | VARIANT_FALSE | R |
| DBPROP_QUICKRESTART | VARIANT_FALSE | R/W |
| DBPROP_REMOVEDELETED | VARIANT_FALSE | R/W |
| DBPROP_ROWTHREADMODEL | DBPROPVAL_RT_FREETHREAD | R |
| DBPROP_SERVERCURSOR | VARIANT_TRUE | R |
| DBPROP_SERVERDATAONINSERT | VARIANT_FALSE | R |
| DBPROP_UNIQUEROWS | VARIANT_FALSE | R/W |
| DBPROP_UPDATABILITY | 0 | R/W |
| Properties | Default Value | R/W |
|---|---|---|
| DBPROP_ISLONGMINLENGTH | 32000 | R/W |
| Properties | Default Value | R/W |
|---|---|---|
| DBPROP_SESS_AUTOCOMMITISOLEVELS | DBPROPVAL_TI_CURSORSTABILITY | R/W |
Note:
- The timeout is applicable only when using the TCP/IP protocol to connect to the server. The timeout is enforced only during the TCP/IP sock connect. If the sock connect completes before the specified timeout expires, the timeout will no longer be enforced for the rest of the initialization process. If the client-reroute feature is used then the timeout will be doubled. In general, when client reroute is enabled, the connection timeout behavior is dictated by client reroute.