How to get Sequence names from the DB2 database.

[stephenraj]

Hi,

How to retrieve the sequence names from the db2 database. It is retrieved by use of tables like USER_SEQUENCE and ALL_SEQUENCES in case of oracle.

How it is done in case of DB2. If i can get the exact the SQL Statement for both these tables it is well and good.

Please reply me immediately.

Thank U,

Regards
Stephenraj

 

[sathyarams]

SYSCAT.SEQUENCES and SYSCAT.SEQUENCEAUTH Views ... Check the SQL Reference for details on these views.

HTH

Cheers

Sathyaram More DB2 questions answered at

http://www.dbforums.com/f8

 

[stephenraj]

Hi Sathyaram,

Thanx a lot for for ur valuable help.

Regards,

stephenraj