Where to find Netezza Sequence data?

user_2384778 0
Viewed 1910

Information about sequences can be found in the _vt_sequence view which can be joined with _v_sequence on _v_sequence.objid = _vt_sequence.seq_id.

sequence fetch query : 

select vs.* , vts.*
from  _v_sequence vs join _vt_sequence vts on vs.objid = vts.seq_id;

Following values generated out of queries :

OBJID
SEQNAME
OWNER
CREATEDATE
OBJTYPE
OBJCLASS
OBJDELIM
DATABASE
OBJDB
SCHEMA
SCHEMAID
SEQ_ID
DB_ID
DATA_TYPE
MIN_VALUE
MAX_VALUE
CYCLE
INCREMENT
CACHE_SIZE
NEXT_CACHE_VAL
FLAGS

Sample CREATE SEQUNCE:

CREATE SEQUENCE TEMP_PPC_SEQ AS BIGINT
START WITH 1
INCREMENT BY 2
NO MINVALUE
MAXVALUE 2147483647
NO CYCLE;

There is no value for START of sequence. Help to fetch START value of each sequence.

netezza sequence
2 Answers

You can find start value in sequence table. Unfortunately netezza don't update last value in this table. Your answer is 

SELECT s.LAST_VALUE
  FROM sequence1 s;
user_82316710
Related