sysibm.sysdummy1 has 1 row in it. If you do
select 1 from myTable
you will also get as many rows as are in the table. I often do
select * from myTable where key = IDENTITY_VAL_LOCAL() to get back
what's really in the table after triggers, default values etc.

If you don't have a where it's likely you will get more than 1 row.

Reply via email to