How to list the avail. sequence

[c***@hotmail.com]

Hi,

Is there anyway to list all the available sequence in the database?
If yes how?

In Control Center and/or SQL....:)

Thanks in advance.

[b***@to.com]

Hi,

SQL: "SELECT SEQNAME FROM SYSIBM.SYSSEQUENCES"

Greetings from Stuttgart,
Bogdan

[Knut Stolze]

Post by b***@to.com
SQL: "SELECT SEQNAME FROM SYSIBM.SYSSEQUENCES"

If you are on DB2 LUW, you should use the catalog view SYSCAT.SEQUENCES
instead - to avoid dependencies on internal, undocumented tables.