Db2 Developer-C 11.1

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table DEMO (n int);
begin transaction;
[IBM][CLI Driver][DB2/LINUXX8664] SQL0104N  An unexpected token "transaction" was found following "begin ".  Expected tokens may include:  "<psm_function_compound_stmt>".  LINE NUMBER=1.  SQLSTATE=42601 SQLCODE=-104

insert into DEMO values (0);
select n "after insert" from demo;

after insert

0

update DEMO set n=1/n;
[IBM][CLI Driver][DB2/LINUXX8664] SQL0801N  Division by zero was attempted.  SQLSTATE=22012 SQLCODE=-801

select n "after error" from DEMO;

after error

0

commit;
select n "after commit" from DEMO;

after commit

0