Scalable Database Server, HiRDB Version 8 UAP Development Guide

[Contents][Index][Back][Next]

4.12.4 Action if a rollback occurs for a transaction that uses a list

If a transaction is cancelled by the ROLLBACK statement of SQL or an error, you many need to re-create a list that was created or deleted by that transaction. The following table describes the user action to be taken depending on the status of a list that had been created or deleted when a transaction was cancelled.

List operation in cancelled transaction List status User action
List created with ASSIGN LIST statement in the transaction If the list was created with a list name that did not exist before the transaction was started The list that was created cannot be found. Reexecute the transaction process.
If the list was created with a list name that existed before the transaction was started The list that had the same list name before the transaction was started cannot be used. (An error occurs if the list is searched.)* To use the list that had the same list name before the transaction was started in the transaction, re-create the list. Then reexecute the transaction.
List to be deleted by DROP LIST statement in the transaction If the deletion-target list did not exist before the transaction was started The list that was deleted cannot be found. Reexecute the transaction process.
If the deletion-target list existed before the transaction was started The list that did not exist before the transaction was started cannot be found. The deletion-target list that existed before the transaction was started cannot be used. (An error occurs if the list is searched.)* To use the deletion-target list that existed before the transaction was started in the transaction, re-create that list. Then reexecute the transaction.

* Depending on when the transaction was cancelled, you still may be able to use the list normally.