By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1451419 fiddles created (18721 in the last week).
create table DEMO (n int);
✓
hidden batch(es)
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
hidden batch(es)
insert into DEMO values (0);
✓
hidden batch(es)
select n "after insert" from demo;
after insert
0
…
hidden batch(es)
update DEMO set n=1/n;
[IBM][CLI Driver][DB2/LINUXX8664] SQL0801N Division by zero was attempted. SQLSTATE=22012 SQLCODE=-801
