SeqNumber - Teradata Vantage

Function of SeqNumber

Generates sequential alternate keys to be used by other QCD tables.

Each column in the table (except QCDVersion, DemographicsID, and StatisticsID) is initialized to 1 and then incremented after each use.

SeqNumber Table Definition

The following CREATE TABLE request defines the SeqNumber table:

   CREATE TABLE SeqNumber (
     PIndex           INTEGER NOT NULL,
     WorkLoadID       INTEGER NOT NULL,
     MachConfigID     INTEGER NOT NULL,
     QueryID          INTEGER NOT NULL,
     UDB_KEY          INTEGER NOT NULL,
     StepID           INTEGER NOT NULL,
     RelationKey      INTEGER NOT NULL,
     PredicateID      INTEGER NOT NULL,
     RecommendationID INTEGER NOT NULL,
     QCDVersion       VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
     DemographicsID   INTEGER NOT NULL,
     StatisticsID     INTEGER NOT NULL)
   PRIMARY INDEX (PIndex)
   UNIQUE INDEX (RelationKey);

Table Initialization Statement

SeqNumber is initialized by the following INSERT request.

   INSERT INTO SeqNumber VALUES(1,1,1,1,1,1,1,1,1,’QCF03.00.00’,2,2);

Attribute Definitions for SeqNumber

The following table defines the SeqNumber table attributes: