Updated: 2018-05-04
Session OLE DB Property — «Session AutoCommit DDL»
Name:
Session AutoCommit DDL
Type:
VT_I4
R/W:
R/W
Default:
It derives initialization property auto_commit_ddl
IBProvider:
1, 2, 3, 5
DDL queries (CREATE/ALTER/DROP) execution mode. Allowed values:
| Value | Description |
| 0 | Support of DDL queries is off. |
| 1 | Executing DDL query in a transaction. Ignored if auto-commit mode. |
| 2 | Execute CommitRetaining after DDL query. Ignored if auto-commit mode. |
If you need to execute the mixed sequence of DDL and DML queries you should set the property to 1.
Default value (0) means that when using the explicit transaction control (auto_commit=false) the metadata update will applied only after commit.
See also
- The session property Session AutoCommit DDL Level
- The session property Session AutoCommit
- The initialization property auto_commit_ddl