Hi,
I am having some problem with sequence.
This is how i create a sequence. Programming Language - Pro*C ( Linux )
CREATE SEQUENCE TransId_Seq
START WITH 1
INCREMENT BY 1
MAXVALUE 100000000
NOCYCLE ;
I entered 10 transaction yesterday. If i enter another transaction today ,the
sequence TransId_Seq should start from 11. But it is starting from 22 . We haven't
entered any transaction in the mean time . We have tested this several times. The
number generated by sequence is not continuous. ( We are using TransId_Seq.NextVal to
get the Sequence value )
Continuously using sequence does not cause any problem. But if there is a
break for 1 or 2 days then we are facing this problem.
With Regards,
Pavithra.P
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
