SYSIBM.SYSKEYCOLUSE
                        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 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