SELECT nextval FOR schema.sequence AS id
FROM dual

SELECT nextval FOR schema.sequence AS id1,
       nextval FOR schema.sequence AS id2
FROM dual

ID1         ID2
----------- -----------
        643         643

  1 record(s) selected.

SELECT nextval FOR schema.sequence AS id
FROM (SELECT 1 FROM dual UNION ALL SELECT 1 FROM dual) temp

ID
-----------
        669
        670

  2 record(s) selected.

db2inst1:/> db2 select current_timestamp from sysibm.sysdummy1

1
--------------------------
1970-12-31-23.59.59.000000

  1 record(s) selected.

db2inst1:/> db2 describe table sysibm.sysdummy1

                                Data type                     Column
Column name                     schema    Data type name      Length     Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
IBMREQD                         SYSIBM    CHARACTER                    1     0 No

  1 record(s) selected.

VALUES NEXT VALUE FOR schema.sequence, NEXT VALUE FOR schema.sequence;

VALUES (NEXT VALUE FOR schema.sequence, NEXT VALUE FOR schema.sequence);