Hi,

I believe that
[not atomic] procedure doesn't do either COMMIT nor ROLLBACK,
but the caller can determine COMMIT or ROLLBACK.

I called the below TEST_PROC procedure like this:

db2⇒call TEST_PROC ()
db2⇒commit

and then, I checked TBL cl_sched,
but I couldn't find record (1).

Why?

Thanks in advance

'----------------------------------------------------------
CREATE PROCEDURE TEST_PROC ()
LANGUAGE SQL
BEGIN NOT ATOMIC

INSERT INTO cl_sched (class_code, day)
VALUES ('R11:TAA', 1);<----------------(1)

SIGNAL SQLSTATE '70000';

INSERT INTO cl_sched (class_code, day)
VALUES ('R22:TBB', 2);
END

'----------------------------------------------------------
Version:
DB2 Version 9.5 SQL PL