SAVEPOINT

保存点

常用释义

保存点

扩展信息

保存点

保存点保存点（Savepoint）是 iSeries 移植过程中常常碰到的难以模拟的另一项功能。现在，在 V5R2 iSeries 中，您可以利用 …

回滚点

两段式提交就是分布式提交，是需要设备回滚点（SAVEPOINT）的。每个回滚点的回滚方式类似于一个自治事务，有自己的回 …

设置保存点

On the way » Oracle PL/SQL 3 days ... check 约束： savepoint 设置保存点 UPDATE 修改字段值： ...

储存点

储存点 (Savepoint) 提供回复部份交易的机制。您可以使用 SAVE TRANSACTION savepoint_name 陈述式来建立储存点。

标记事务中可以回滚的点

oracle命令大全（转） - shengel - 博客园 ... COMMIT - 提交并结束事务处理 SAVEPOINT – 标记事务中可以回滚的点 GRANT …

保存点以标识回滚位置

...savepoint](ROLLBACK) 　　设置保存点以标识回滚位置(SAVEPOINT) 　　设置事务的属性(SET TRANSACTION)　　会话控制语句[sess…

设置保存点以标识回滚位置

... 将事务对数据的修改永久地保存到数据库（ COMMIT） 设置保存点以标识回滚位置（ SAVEPOINT）设置事务的属性（ SE…

例句

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.

您可以在存储过程中使用所有保存点语句。