查询sequence: SELECT * FROM SYSCAT.SEQUENCES
CREATE sequence seq_userid AS INTEGER START WITH 1000 increment BY 1;
insert into user(id, name) values(NEXTVAL FOR seq_userid,'ddddd');
SELECT NEXTVAL FOR SEQ_USERID FROM user WHERE id=1000
查询sequence: SELECT * FROM SYSCAT.SEQUENCES