SQL - SYSIBM.SYSCHECKS2 - 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.SYSCHECKS2
Contains one row for each table check constraint for catalog tables created in or after Version 7.
Check constraints for catalog tables created before Version 7 are not included in this table.

Nome da coluna Tipo do dado Descrição Uso
 TBOWNER  CHAR(8) NOT NULL  Authorization ID of the owner of the table on which the table check constraint is  defined.  G
 TBNAME  VARCHAR(18) NOT NULL  Name of the table on which the check constraint is defined.  G
 CHECKNAME  VARCHAR(128) NOT NULL  Table check constraint name.  G
 PATHSCHEMAS  VARCHAR(254) NOT NULL  SQL path at the time the table check constraint was created. The path is used to  resolve unqualified cast function names that are used in the constraint definition.  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

© Copyright IBM Corp.