Nonstop Database, HiRDB Version 9 UAP Development Guide
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.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.