1

I am new to Netezza and have a quick question.

I do a simple select of next val from sequence

SELECT NEXT VALUE FOR XX.XX.RUN_SEQ FROM _V_DUAL I

ERROR [HY000] ERROR: Sequence 46339885 not properly initialized

I get the above error, can some one help?

DDL:

CREATE SEQUENCE XX.RUN_SEQ AS BIGINT
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE 
    NO MAXVALUE 
    NO CYCLE;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.