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? Jon Bloom _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
