View Current Value of DB2 Sequence

To see the current value of a sequence, you can use the following SQL statement:

SELECT NEXT VALUE FOR your_sequence_name FROM sysibm.sysdummy1;

Please replace your_sequence_name with the name of the sequence you want to view. This SQL statement will return the current value of the sequence.