SYSIBM.SYSSEQUENCES
                        www.cadcobol.com - linguagem de programação COBOL

Volta a página anterior

Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF.

Contains one row for each identity column.

Nome da coluna Tipo do dado Descrição Uso
 SCHEMA  CHAR(8) NOT NULL  The value of TBCREATOR from the SYSCOLUMNS entry for the identity column.  G
 OWNER  CHAR(8) NOT NULL  The value of TBCREATOR from the SYSCOLUMNS entry for the identity column.  G
 NAME  CHAR(18) NOT NULL  Name that DB2 generated for the identity column.  G
 SEQTYPE  CHAR(1) NOT NULL  Type of entry:

 I        For an identity column		  G
 SEQUENCEID  INTEGER NOT NULL  Internal identifier of the identity column.  G
 CREATEDBY  CHAR(8) NOT NULL  The authorization ID under which the identity column was created.  G
 INCREMENT  DECIMAL(31,0) NOT NULL  Increment value (positive or negative, within INTEGER scope).  G
 START  DECIMAL(31,0) NOT NULL  Start value.  G
 MAXVALUE  DECIMAL(31,0) NOT NULL  Maximum value allowed for the identity column.  G
 MINVALUE  DECIMAL(31,0) NOT NULL  Minimum value allowed for the identity column.  G
 CYCLE  CHAR(1) NOT NULL  Whether values for the identity column are wrapped (values continue to be  generated for the column after the maximum or minimum value is reached):

 N      No
 Y      Yes		  G
 CACHE  INTEGER NOT NULL  Number of identity column values to preallocate in memory for faster access. A  value of 0 indicates that values are not to be preallocated.  G
 ORDER  CHAR(1) NOT NULL  The value is always 'N' for an identity column.  G
 DATATYPEID  INTEGER NOT NULL  For a built-in data type, the internal ID of the built-in type. For a distinct type, the  internal ID of the distinct type.  S
 SOURCETYPEID  INTEGER NOT NULL  For a built-in data type, 0. For a distinct type, the internal ID of the built-in data  type upon which the distinct type is sourced.  S
 CREATEDTS  TIMESTAMP NOT NULL  Timestamp when the identity column was created.  G
 ALTEREDTS  TIMESTAMP NOT NULL  Timestamp when the identity column was created.  G
 MAXASSIGNEDVAL  DECIMAL(31,0)  Last possible assigned value. Initialized to null when the sequence object is  created. Updated each time the next chunk of n values is cached, where n is the  value for CACHE.  G
 IBMREQD  CHAR(1) NOT NULL  A value of Y indicates that the row came from the basic machine-readable material  (MRM) tape. For all other values, see Release dependency indicators in topic D.0.  G
 REMARKS  VARCHAR(254) NOT NULL  The value is always blank for an identity column.  G