SQL - SYSIBM.SYSKEYCOLUSE - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSKEYCOLUSE
Contains a row for every column in a unique constraint (primary key or unique key) from the SYSIBM.SYSTABCONST table.

Nome da coluna Tipo do dado Descrição Uso
 CONSTNAME  VARCHAR(128) NOT NULL  Name of the constraint.  G
 TBCREATOR  CHAR(8) NOT NULL  Authorization ID of the owner of the table on which the constraint is defined.  G
 TBNAME  VARCHAR(18) NOT NULL  Name of the table on which the constraint is defined.  G
 COLNAME  VARCHAR(18) NOT NULL  Name of the column  G
 COLSEQ  SMALLINT NOT NULL  Numeric position of the column in the key (the first position in the key is 1).  G
 COLNO  SMALLINT NOT NULL  Numeric position of the column in the table on which the constraint is defined.  G
 IBMREQD  CHAR(1) NOT NULL
 WITH DEFAULT 'N'		  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

© Copyright IBM Corp.