Paul,

BEGIN ATOMIC .. END
Compiles the multiple statements into one plan.
It does not change the statement level semantics.
Semantically BEGIN ATOMIC .. END also introduces a safepoint (hence ATOMIC)

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab