SQL - SYSIBM.SYSCONSTDEP - 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.SYSCONSTDEP
Records dependencies on check constraints or user-defined defaults for a column.

Nome da coluna Tipo do dado Descrição Uso
 BNAME  VARCHAR(18) NOT NULL  Name of the object on which the dependency exists.  G
 BSCHEMA  CHAR(8) NOT NULL  Schema of the object on which the dependency exists.  G
 BTYPE  CHAR(1) NOT NULL  Type of object on which the dependency exists:

 F        Function instance
 G        Temporary table
 G
 DTBNAME  VARCHAR(18) NOT NULL  Name of the table to which the dependency applies.  G
 DTBCREATOR  CHAR(8) NOT NULL  Authorization ID of the owner of the table to which the dependency applies.  G
 DCONSTNAME  VARCHAR(128) NOT NULL  If DTYPE = 'C', the unqualified name of the check constraint. If DTYPE = 'D', a  column name.  G
 DTYPE  CHAR(1) NOT NULL  Type of object:

 C        Check constraint
 D        User-defined default constant
 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.