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语句。