|
SYSIBM.SYSCHECKS www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
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 |