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;
Glorfindel
  • 2,205
  • 5
  • 19
  • 26

0 Answers0