TT-06230
Cannot perform DML such as update and DDL such as create index or alter table in same transaction when using DDLCommitBehavior=1
Cause
This error is returned when using DDLCommitBehavior=1. If DDLCommitBehavior=1, TimesTen allows multiple DML and DDL statements in the same transaction. However, some mixes of DML and DDL in the same transaction while using DDLCommitBehavior=1 are no longer allowed. For example, you will see this error when updating rows in a table and then creating an index on that same table (or updating rows in a table and then resizing that table's hash index with ALTER TABLE ... PAGES = n).
Action
To prevent this error, do not mix DML and DDL in the same transaction. Ensure that the DDL operation is in its own transaction.
Additional Information
TimesTen cannot perform the operation.
TT-06230
Cannot perform DML such as update and DDL such as create index or alter table in same transaction when using DDLCommitBehavior=1
Cause
This error is returned when using DDLCommitBehavior=1. If DDLCommitBehavior=1, TimesTen allows multiple DML and DDL statements in the same transaction. However, some mixes of DML and DDL in the same transaction while using DDLCommitBehavior=1 are no longer allowed. For example, you will see this error when updating rows in a table and then creating an index on that same table (or updating rows in a table and then resizing that table's hash index with ALTER TABLE ... PAGES = n).
Action
To prevent this error, do not mix DML and DDL in the same transaction. Ensure that the DDL operation is in its own transaction.
Additional Information
TimesTen cannot perform the operation.
TT-06230
Cannot perform DML such as update and DDL such as create index or alter table in same transaction when using DDLCommitBehavior=1
Cause
This error is returned when using DDLCommitBehavior=1. If DDLCommitBehavior=1, TimesTen allows multiple DML and DDL statements in the same transaction. However, some mixes of DML and DDL in the same transaction while using DDLCommitBehavior=1 are no longer allowed. For example, you will see this error when updating rows in a table and then creating an index on that same table (or updating rows in a table and then resizing that table's hash index with ALTER TABLE ... PAGES = n).
Action
To prevent this error, do not mix DML and DDL in the same transaction. Ensure that the DDL operation is in its own transaction.
Additional Information
TimesTen cannot perform the operation.
