[EMAIL PROTECTED] 

> 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,.....

we discussed this several times in this list (see the archive)
and I was sure that I changed this behaviour with kernel version 7.3.0.18.
Which version do you use?

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

Reply via email to