Hitachi

Hitachi Advanced Database Messages


KFAA31662-E

The SQL statement cannot be executed because a aa....aa table is being manipulated in a transaction. (M+J+O)

The SQL statement cannot be executed because the aa....aa table is being referenced in the same transaction. <SQLSTATE: 53027>

If a definition SQL statement cannot be executed, either of the following tables is being referenced in the same transaction:

  • Dictionary table that will be referenced and updated in an extension of the definition SQL statement

  • Table that will be changed and deleted by the definition SQL statement

If the TRUNCATE TABLE statement or PURGE CHUNK statement cannot be executed, the operation target table is being referenced.

aa....aa: Table being referenced in the transaction
  • dictionary: Dictionary table that will be referenced and updated in an extension of the definition SQL statement

  • user: Table that will be changed and deleted by the definition SQL statement, or the table specified in the TRUNCATE TABLE statement or PURGE CHUNK statement

S:

Invalidates this transaction.

Action:

Re-execute the SQL statement.