title: Why Netezza Sequence next value giving random values?
body: <p>Sequence: </p>
  
  <pre><code>CREATE SEQUENCE STG.TEMP_PPC_SEQ AS BIGINT
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      MAXVALUE 2147483647
      NO CYCLE;
  </code></pre>
  
  <p>Select Query:</p>
  
  <pre><code>SELECT TPLCST.code,NEXT VALUE FOR STAGING.STG.TEMP_PPC_SEQ
  FROM TEMP_PRODUCT_LIFE_CYCLE_STATUS_TYPE TPLCST
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>CODE    NEXTVAL
  30  8
  80  10008
  40  30008
  50  40015
  10  40016
  20  20008
  </code></pre>
  
  <p>I am getting nextval random. How can I make them sequential? </p>