Cacher is the code snippet organizer for pro developers

UPDATE COMMAND OPTIONS USING c OFF;
INSERT INTO TESTE VALUES (1,'a');
INSERT INTO TESTE VALUES (2,'b');
INSERT INTO TESTE VALUES (3,'c');
INSERT INTO TESTE VALUES (4,'d');
COMMIT;

begin atomic
insert into db2inst1.x0 (nome) values ('cd');
insert into db2inst1.x1  (cod) values (select identity_val_local() from sysibm.sysdummy1);
end@