The procedure sets a savepoint named neworder.
该过程设置了一个名为 neworder 的保存点。
The svpt1 identifier is the name of the savepoint.
svpt 1标识符是保存点的名称。
You can use all of the savepoint statements within stored procedures.
您可以在存储过程中使用所有保存点语句。
The number of requests for a storage engine to place a savepoint.
存储引擎放置一个保存点的请求数。
Any reference to a released savepoint is invalid and results in an error.
引用已释放的保存点是无效的，并导致一个错误。
The number of requests for a storage engine to roll back to a savepoint.
存储引擎回滚到一个保存点的请求。
Therefore, a savepoint name needs to be unique only in its scope of execution.
因此，保存点的名称只需在其执行范围内保持惟一。
In the coming SQL3, the concepts of savepoint and partial rollback are specified.
在即将推出的SQL3中，明确了保存点和部分回滚的概念。
If there is an error, the program rolls back the transaction to the neworder savepoint.
如果出现错误的话，程序将把事务回滚到neworder保存点。
Setting another savepoint named newcustomer with the UNIQUE keyword results in an error.
使用UNIQUE 关键字设置另一个名为newcustomer 的保存点将生成一个错误。
Furthermore, we discuss the application of savepoint in the work-flow transaction field.
最后给出保存点在工作流事务中的应用。
Rolls back a transaction from a pending state, and specifies the transaction or savepoint name.
从挂起状态回滚事务，并指定事务或保存点名称。
This rollback undoes all the operations that were performed after the neworder savepoint was set.
这个回滚将撤销在设置 neworder 保存点之后执行的所有操作。
The code sets a savepoint with the same newcustomer name as the savepoint set inside the procedure.
代码设置了一个与过程内部设置的保存点同名的newcustomer保存点。
When a transaction rolls back to a savepoint, all non-hold cursors opened after that savepoint are closed.
当一个事务回滚到某个保存点时，在保存点之后打开的所有未被占用的指针将被关闭。
In the case of an error, the transaction logic can specify that the transaction rollback to a savepoint.
在发生错误的情况下，事务逻辑可以指定该事务回滚到某个保存点。
When used, it specifies that this is meant to be a unique savepoint within the scope of the current transaction.
在使用时，它表示该保存点是当前事务范围内惟一的保存点。
This section describes the SQL statements that were introduced with IDS 11.50.xc3 to support savepoint processing.
本节介绍了IDS 11.50 .xC3为了支持保存点处理而引入的sql语句。
When used, the statement rolls back the part of the transaction that occurred after the savepoint identified by svpt1.
当使用该语句时，将回滚到发生在svpt1 保存点之后的操作。
The ROLLBACK statement would fail with the error: Rollback to savepoint disallowed on updating an old server in same transaction.
ROLLBACK语句将失败并收到一个错误：保存点回滚不允许在同一事务中更新较旧的服务器。
On rolling back to a savepoint, all the logged temp tables - data and schema - are restored to their states prior to setting the savepoint.
在回滚保存点时，所有已登录的temp表—数据和模式—都被恢复到设置保存点之前的状态。
If a savepoint with the same name that is specified for svpt1 already exists in the same transaction, this statement generates an error.
如果同一个事务中已经存在一个和svpt 1同名的保存点，那么该语句将生成一个错误。
Procedure calls can be nested or recursive, but the scope of a savepoint is restricted to the execution of the stored procedure in which it is defined.
过程调用可以是嵌套的或递归的，但是保存点的范围被限制为定义它的存储过程的执行。
When you rollback to a savepoint set earlier in a transaction, IDS just rolls back all the operations logged by the transaction after the savepoint was set.
当回滚到事务中早先设置的保存点时，IDS将只回滚在设置保存点后由事务记录的所有操作。
The example in Listing 11 connects to a local database named ldb, sets savepoints, performs operations on remote databases, and rolls back to a savepoint.
清单11中的示例连接到一个名为ldb 的本地数据库，设置保存点并在远程数据库上执行操作，然后回滚到保存点。
If the available quantity from the stock table for the requested item is less than the quantity ordered, the transaction rolls back to the neworder savepoint.
如果所请求商品在stock表中的可用数量小于订购的数量，那么事务将回滚到neworder保存点。
This also means that you can refer to a savepoint only in the same execution of a procedure, but not from another execution of the same or other procedures irrespective of the nesting level.
这也意味着您只能在存储过程的同一次执行中引用保存点，而不能从同一个过程或任何嵌套级别的其他过程的不同执行中引用。
Although the new order cannot be entered, the new customer addition still passes with the procedure execution, and is rolled back with the final rollback to savepoint in the main transaction.
尽管不能输入新的订单，但是添加新客户的操作仍然通过了过程执行，并且通过在主事务中最后的保存点回滚完成了回滚。
ROLLBACK statement without a transaction or savepoint name always rolls back statements to the outermost BEGIN transaction (explicit or implicit) statement, and cancels the entire transaction.
没有事务名称或保存点名称的ROLLBACK语句总是将语句回退到最外层的BEGINTRANSACTION(显式或隐式)语句，并且取消整个事务。
The procedure rolls back to its newcustomer savepoint ending up retaining the new customer that was added after the procedure execution, but this is also rolled back with the ROLLBACK statement.
清单8.1中的过程回滚到其newcustomer保存点，但是仍然保留在过程执行后添加的新客户，但是在清单8.2中也使用了rollback语句执行了回滚。
应用推荐