I do not get Db2 to work This works: Select 'a' || 'b' as test from sysibm.sysdummy1; But to create a table and insert a row does not produce any response or result set: create table koe (s1 integer); insert into koe values (1); select * from koe;
Seems to work ok to me: https://dbfiddle.uk/YjwM7Get