您可以在存储过程中使用所有保存点语句。
You can use all of the savepoint statements within stored procedures.
它允许您在事务中设置、回滚和释放保存点。
This lets you set, rollback, and release savepoints in a transaction.
存储引擎放置一个保存点的请求数。
The number of requests for a storage engine to place a savepoint.
存储引擎回滚到一个保存点的请求。
The number of requests for a storage engine to roll back to a savepoint.
引用已释放的保存点是无效的，并导致一个错误。
Any reference to a released savepoint is invalid and results in an error.
svpt 1标识符是保存点的名称。
IDS的保存点实现遵循SQL- 99标准。
The IDS implementation of savepoints follows the SQL-99 standard.
保存点指的是数据库事务中指定的标记。
清单9.1在存储过程中使用保存点的样例代码。
Listing 9.1. Sample code using savepoints in stored procedures.
清单8.2在存储过程中使用保存点的样例代码。
Listing 8.2. Sample code using savepoints in stored procedures.
清单9.3在存储过程中使用保存点的样例代码。
Listing 9.3. Sample code using savepoints in stored procedures.
清单9.2在存储过程中使用保存点的样例代码。
Listing 9.2 Sample code using savepoints in stored procedures.
清单8.1在存储过程中使用保存点的样例代码。
Listing 8.1. Sample code using savepoints in stored procedures.
因此，保存点的名称只需在其执行范围内保持惟一。
Therefore, a savepoint name needs to be unique only in its scope of execution.
这演示了在您希望仅回滚事务的一小部分的保存点。
This illustrates the use of savepoints in a scenario where you would want to rollback just a small part of a transaction.
分布式事务中的保存点。
本文的下一小节将描述在存储过程上下文中使用保存点。
The next section of this article describes the usage of savepoints in the context of stored procedures.
保存点是在事务中实现更细粒度的原子性的最佳方法。
Savepoints are the perfect mechanism to achieve finer granularity of atomicity within a transaction.
存储过程内部设置的保存点的范围被限制为存储过程的单次执行。
The scope of savepoints set inside a stored procedure is restricted to the individual execution of the stored procedure.
在发生错误的情况下，事务逻辑可以指定该事务回滚到某个保存点。
In the case of an error, the transaction logic can specify that the transaction rollback to a savepoint.
该过程设置了一个名为 neworder 的保存点。
在使用时，它表示该保存点是当前事务范围内惟一的保存点。
When used, it specifies that this is meant to be a unique savepoint within the scope of the current transaction.
在即将推出的SQL3中，明确了保存点和部分回滚的概念。
In the coming SQL3, the concepts of savepoint and partial rollback are specified.
可以使用标记或标签返回到变更保存点，以撤销变更，或者审计特定的变更。
You can use the tag or label to get back to the point where the changes were saved, to undo a change, or to audit a particular change.
如果出现错误的话，程序将把事务回滚到neworder保存点。
If there is an error, the program rolls back the transaction to the neworder savepoint.
当使用该语句时，将回滚到发生在svpt1 保存点之后的操作。
When used, the statement rolls back the part of the transaction that occurred after the savepoint identified by svpt1.
您可以在由IDS客户机API或任何语言编写的应用程序中使用保存点。
You can use savepoints in applications written with any IDS client API or language.
这个回滚将撤销在设置 neworder 保存点之后执行的所有操作。
This rollback undoes all the operations that were performed after the neworder savepoint was set.
过程调用可以是嵌套的或递归的，但是保存点的范围被限制为定义它的存储过程的执行。
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.
代码设置了一个与过程内部设置的保存点同名的newcustomer保存点。
The code sets a savepoint with the same newcustomer name as the savepoint set inside the procedure.
应用推荐