savepoint

savepoint

 英

  • 網絡保存點;回滾點;設置保存點

例句

Rolls back an explicit or implicit transaction to the beginning of the transaction, or to a savepoint inside the transaction.

事務隱性事務事務起點事務某個保存

When used, it specifies that this is meant to be a unique savepoint within the scope of the current transaction.

使用表示保存當前事務范圍惟一保存

Rollback of a user-specified transaction to the last savepoint inside a transaction or to the beginning of a transaction.

用戶指定事務事務上一個保存事務開頭

In the case of an error, the transaction logic can specify that the transaction rollback to a savepoint.

發生錯誤情況事務邏輯可以指定事務回滾某個保存

The ROLLBACK statement would fail with the error: Rollback to savepoint disallowed on updating an old server in same transaction.

ROLLBACK語句失敗收到一個錯誤保存允許同一事務更新服務器

When a transaction rolls back to a savepoint, all non-hold cursors opened after that savepoint are closed.

一個事務某個保存保存之后打開所有占用指針關閉

Or, if the optional svpt1 identifier is not used, rollback happens to the last savepoint specified in the current transaction.

或者如果沒有使用svpt1標識符當前事務指定最近一個保存執行

All locks acquired after the specified SAVEPOINT statement are retained until the end of the transaction.

指定SAVEPOINT語句之后獲得所有仍然保留直到事務結束

Therefore, a savepoint name needs to be unique only in its scope of execution.

因此保存名稱只需執行范圍內保持惟一

Any reference to a released savepoint is invalid and results in an error.

引用釋放保存無效導致一個錯誤

The example in Listing 3 demonstrates the usage of the SAVEPOINT statement in a transaction connected to the stores_demo database.

清單3示例演示一個連接stores_demo數據庫事務使用SAVEPOINT語句

No transaction or savepoint of that name was found .

沒有找到任何名稱事務保存

It sets a savepoint named newcustomer before inserting a new customer and a savepoint named neworder before adding the new customer's order.

插入一個客戶之前設置一個newcustomer保存添加客戶訂單之前添加一個neworder保存

Any rollbacks to the savepoint fail if any updates were made on an older server.

如果服務器執行更新的話保存執行任何回滾都會失敗

Setting another savepoint named newcustomer with the UNIQUE keyword results in an error.

使用UNIQUE關鍵字設置另一個newcustomer保存點將生成一個錯誤

SAVEPOINT statement defines an intermediate point during a transaction .

SAVEPOINT語句定義事務執行過程中間

When used, the statement rolls back the part of the transaction that occurred after the savepoint identified by svpt1.

使用語句發生svpt1保存之后操作

Method to roll back to the savepoint instead of rolling back to the start of the transaction.

方法保存不是事務起點

The svpt1 identifier is the name of the savepoint.

svpt1標識符保存名稱

The SAVEPOINT statement sets a savepoint at the current position in the transaction.

SAVEPOINT語句事務當前位置設置一個保存

These square brackets indicate that the savepoint-name is optional.

上面方括號表示savepoint-name可選

Once a RELEASE SAVEPOINT statement has been executed or the transaction has ended, you can no longer use the savepoint.

執行RELEASESAVEPOINT語句事務結束不能使用保存

Applications using other clients can use savepoints in IDS by sending the savepoint statements directly to the server.

使用其他客戶機應用程序可以IDS使用保存只需保存語句直接送給服務器

The code sets a savepoint with the same newcustomer name as the savepoint set inside the procedure.

代碼設置一個過程內部設置保存同名newcustomer保存

LSN of the most recent savepoint for the transaction in the database log.

數據庫日志事務最近保存LSN

This rollback undoes all the operations that were performed after the neworder savepoint was set.

這個撤銷設置neworder保存之后執行所有操作

The example in Listing 5 demonstrates the effect of a RELEASE SAVEPOINT statement.

清單5示例演示RELEASESAVEPOINT語句效果

You can undo all changes after that point using a ROLLBACK TO SAVEPOINT statement.

使用ROLLBACKTOSAVEPOINT語句可以撤消所有更改

Review savepoint and mark options for transactions.

檢查事務保存標記選項

You can use all of the savepoint statements within stored procedures.

可以存儲過程使用所有保存語句

Any non-hold cursor opened after the specified SAVEPOINT statement is closed.

任何指定SAVEPOINT語句之后打開占用指針關閉

If a 547 error occurs, it rolls back to the savepoint and returns the number of items on hand to the calling process.

如果出現547錯誤保存當前手邊有的項目返回調用進程

Explicitly release the given savepoint.

釋放一個給定

As described earlier, you set savepoints with the SAVEPOINT statement.

使用SAVEPOINT語句設置保存

A new class, IfxSavepoint, implements the java. sql. Savepoint interface.

一個IfxSavepoint實現java.sql.Savepoint接口

You create a savepoint using the SAVE TRANSACTION savepoint_name statement.

可以使用SAVETRANSACTIONsavepoint_name語句創建保存

If there is an error, the program rolls back the transaction to the neworder savepoint.

如果出現錯誤的話程序事務neworder保存

Roll back to the given savepoint.

給定

If you set a savepoint and update a pre-11. 50. xC3 subordinate server in a transaction, you receive a warning.

如果一個事務設置一個保存更新11.50.xC3版本之前服務器那么收到一個警告

This section describes the SQL statements that were introduced with IDS 11. 50. xC3 to support savepoint processing.

介紹IDS11.50.xC3為了支持保存處理引入SQL語句。