Jon Bloom schrieb: > For some reason the sequence I've created seems to keep resetting itself. The >sequence was created using: > > exec sql CREATE SEQUENCE "CERT_REQ_ID_SEQ" INCREMENT BY 1 START WITH 1 NOCYCLE CACHE >1; > > After some indetrminate period of inactivity (hours), the next use of >CERT_REQ_ID_SEQ.NEXTVAL returns 1 and the sequence counts up from there. > > Any ideas?
Hm. Maybe you haven't commited your transaction and it was rolled back after some transaction timeout? Regards, Peter _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
