How to list the avail. sequenceThis is a discussion on How to list the avail. sequence within the db2-udb forums in Other Databases category; 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.... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
09-20-2007, 05:46 AM
|
 How to list the avail. sequence 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.  |
|
#2
09-20-2007, 05:56 AM
|
| Re: How to list the avail. sequence Hi, SQL: "SELECT SEQNAME FROM SYSIBM.SYSSEQUENCES" Greetings from Stuttgart, Bogdan |
|
#3
09-24-2007, 10:21 AM
|
| Re: How to list the avail. sequence bogdan.taru-at-to.com wrote: > 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. -- Knut Stolze DB2 z/OS Utilities Development IBM Germany |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 05:43 AM.
