大家在查： convicted Zahi decontaminating iTV pedros 土崩瓦解旅行团 conversions 獬五金

savepoint

网络保存点；回滚点；设置保存点

savepoint

网络释义

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…

例句：

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 .

将用户指定的事务回滚到事务内的上一个保存点或事务开头。

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

当一个事务回滚到某个保存点时，在保存点之后打开的所有未被占用的指针将被关闭。

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 的保存点。

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 语句或事务结束后，则不能再使用该保存点。

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 .

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

savepoint

savepoint

保存点

回滚点

设置保存点

储存点

标记事务中可以回滚的点

保存点以标识回滚位置

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

热词推荐

大家在看