DBPROP_SUPPORTEDTXNDDL

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_NONE—Transactions are not supported.
• 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.