Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)

2017-07-07 02:10:07

OLE DB Programmer's Reference

Property group: Data Source Information

Property set: DBPROPSET_DATASOURCEINFO

Type: VT_I4

Typical R/W: R

Description: Transaction DDL

Indicates the relationship of transactions to table and index modification data definition language (DDL) statements. One of the following:

DBPROPVAL_TC_DML—Transactions can contain only data manipulation language (DML) statements. Attempting to modify tables or indexes within a transaction causes an error.

DBPROPVAL_TC_DDL_COMMIT—Transactions can contain only DML statements. Modifying tables or indexes within a transaction causes the transaction to be committed. The provider's commit mode remains unchanged in accordance with the value of DBPROP_COMMITPRESERVE. If the provider was in auto-commit mode, it remains in auto-commit mode, and likewise for manual-commit mode.

DBPROPVAL_TC_DDL_IGNORE—Transactions can contain only DML statements. Attempts to modify tables or indexes within a transaction are ignored. Note DDL operations are not transacted even if a session is participating in a transaction. If the DDL method succeeds, the operation is complete and unaffected by subsequent calls to abort or commit the transaction.

DBPROPVAL_TC_DDL_LOCK—Transactions can contain both DML and table or index modifications, but modifying a table or index within a transaction causes the table or index to be locked until the transaction completes.

DBPROPVAL_TC_ALL—Transactions can contain DML statements, as well as table or index modifications, in any order.

Категории