atomic of store procedure

最新推荐文章于 2023-01-15 12:56:39 发布

Angi-WANG

最新推荐文章于 2023-01-15 12:56:39 发布

阅读量110

点赞数

分类专栏： DB2 文章标签： SQL UP

本文链接：https://blog.csdn.net/u012870024/article/details/83877319

版权

DB2 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

not atomic: The procedure neither committed, nor rolled back and this remains to be done for the complete unit of work in which the SQL procedure was called.

atomic: If any unhandled error conditions arise within it, all statements that have executed up to that point are considered to have failed as well and are therefore rolled back.个人发现atomic也需要其调用的客户端去完成UOW。

Atomic compound statements cannot be nested inside other ATOMIC compound statements.

You cannot use the SAVEPOINT statement, the COMMIT statement, or the ROLLBACK statement from within an ATOMIC compound statement. These are only supported in NOT ATOMIC compound statements within SQL procedures.