How can I view the current value of a sequence in db2?

9 months ago

Jackson Davis

1 minute

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.