在db2中发现sequence不能更改,即使使用更改语句来执行成功,它的NEXTCACHEFIRSTVALUE总是1,这样一来我总是无法插入数据,很是郁闷!
------解决方案--------------------------------------------------------
create sequence seq_test as bigint start with 500 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;