KFAA31376-E
The aa....aa cannot be executed because one or more update chunks contains an archived chunk. (chunk ID = bb....bb) (M+J+O)
An attempt to execute the DELETE statement for the archivable multi-chunk table caused an error because the specified search condition did not meet the execution condition of the DELETE statement.
Alternatively, an attempt to execute the UPDATE statement for the archivable multi-chunk table caused an error because the specified search condition did not meet the execution condition of the UPDATE statement. <SQLSTATE: 5100K>
- aa....aa: SQL statement that caused the error
-
-
DELETE statement: DELETE statement
-
UPDATE statement: UPDATE statement
-
- bb....bb:
-
Chunk ID of the chunk subject to execution of the SQL statement
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Confirm that the search condition specified in the UPDATE statement or DELETE statement is appropriate. For details, see the following parts in the manual HADB SQL Reference:
-
Rules in Specification format and rules for the DELETE statement
-
Rules in Specification format and rules for the UPDATE statement
If you want to delete data in an archived chunk, release the chunk bb....bb from the archived state, and then execute the DELETE statement.
If you want to update data in an archived chunk, release the chunk bb....bb from the archived state, and then execute the UPDATE statement.
-