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

Show: