db2里怎么样查询sequence急

谢谢了！
---------------------------------------------------------------

老大，你那不是DB2的语法吧。
在DB2里，直接可以建立一个列作为序号：
CREATE TABLE test
(DEPTNO SMALLINT NOT NULL
GENERATED ALWAYS AS IDENTITY
(START WITH 500, INCREMENT BY 1),
DEPTNAME VARCHAR (36) NOT NULL,
MGRNO CHAR(6),
ADMRDEPT SMALLINT NOT NULL,
LOCATION CHAR(30))

当然如果不嫌麻烦，你也可以建立sequence函数。
---------------------------------------------------------------

To create a sequence in DB2, execute:

create sequence

1<seq-name> start with <val>   
2  
3To get the next value from a sequence, execute:   
4  
5values nextval for <seq-name>   
6  
7To get the current (previous) value from a sequence, execute:   
8  
9values prevval for <seq-name></seq-name></seq-name></val></seq-name>