Hi,
i have a problem with sequences on sapdb!
I created my sequence with the following statement:
CREATE SEQUENCE IDsequence
               INCREMENT BY 1
               START WITH 1
               NOCYCLE NOCACHE ORDER

If i execute the statement:
select IDsequence.nextval from dual;

I get the follwoing numbers: 2,4,6,8,......

How can i configure the sequence, that nextval return me : 2,3,4,5,6,.....

Thanks
Christoph Brunner

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to