Teradata Database Message 5528 - 5528 - Analytics Database - Teradata Vantage

Message

DMLs capturing changed data, DDLs and Comment statements cannot be mixed in a replicated transaction.

Explanation

Normally a DDL is allowed to be the last request in a transaction. Since a replicated transaction uses 2PC protocol, a DDL can not be allowed in such a transaction. For example, BT; <dml> against a replicated table; <ddl> .... NOT ALLOWED! ET; In addition, a COMMENT placing statement follows the same rule as for a DDL statment if the statement text is being captured for replication because either the object is member of a replcation group or by way of a replication rule.

Generated By

RES/OPU modules.

For Whom

End User.

Notes

None

Remedy

None.