SQL - SYSIBM.SYSCHECKS - 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.SYSCHECKS

Contém uma linha para cada 'check constraint' de uma tabela

Nome da coluna Tipo de dado Descrição Uso
 TBOWNER  CHAR(8) NOT NULL  The authorization ID of the owner of the table on which the table check  constraint is defined.  G
 CREATOR  CHAR(8) NOT NULL  The authorization ID of the creator of the table check constraint.  G
 DBID  SMALLINT NOT NULL  The internal identifier of the database for the table check constraint.  S
 OBID  SMALLINT NOT NULL  The internal identifier of the table check constraint.  S
 TIMESTAMP  TIMESTAMP NOT NULL  The time when the table check constraint was created.  G
 RBA  CHAR(6) FOR BIT DATA NOT NULL  The log RBA when the table check constraint was created.  G
 IBMREQD  CHAR(1) NOT NULL  Whether the row came from the basic machine readable material(MRM) tape:
 N No
 Y Yes
 G
 TBNAME  VARCHAR(18) NOT NULL  The name of the table on which the check constraint is defined  G
 CHECKNAME  VARCHAR(128) NOT NULL  The table check constraint name.  G
 CHECKCONDITION  VARCHAR(3800) NOT NULL  The text of the table check constraint.  G


© Copyright IBM Corp.