How to get the next value of sequence?

You need to select from something. Another option is:

db2 => values next value for schema_name.sequence_name;

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

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

db2 => select next value for schema_name.sequence_name from SYSIBM.SYSDUMMY1;

did the trick

Related