SYSIBM.SYSTABCONST
                        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 one row for each unique constraint (primary key or unique key) created in DB2 for OS/390 and z/OS Version 7 or later.

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
 CREATOR  CHAR(8) NOT NULL  Authorization ID under which the constraint was created.  G
 TYPE  CHAR(1) NOT NULL  Type of constraint:

 P        Primary key
 U        Unique key		  G
 IXOWNER  CHAR(8) NOT NULL  Owner of the index enforcing the constraint or blank if index has not been created  yet.  G
 IXNAME  VARCHAR(18) NOT NULL  Name of the index enforcing the constraint or blank if index has not been created  yet.  G
 CREATEDTS  TIMESTAMP NOT NULL  Time when the statement to create the constraint was executed.  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
 COLCOUNT  SMALLINT NOT NULL  Number of columns in the constraint  G