How to get the next value of sequence?
You need to select from something. Another option is:

db2 =&gt; values next value for schema_name.sequence_name;


As you noted you can also use SYSIBM.SYSDUMMY1 or create a virtual table:

db2 =&gt; select next value for schema_name.sequence_name from ( values 1 );