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

Records the dependencies of views on tables and other views.

Nome da coluna Tipo de dados Descrição Uso
 BNAME  VARCHAR(18) NOT NULL  Name of a table or view on which the view is dependent. G
 BCREATOR  CHAR(8) NOT NULL  Authorization ID of the owner of BNAME. G
 BTYPE  CHAR(1) NOT NULL  Type of object BNAME:

 T    Table
 V    View
G
 DNAME  VARCHAR(18) NOT NULL  Name of the view. G
 DCREATOR  CHAR(8) NOT NULL  Authorization ID of the owner of the view. G
 IBMREQD  CHAR(1) NOT NULL  Whether the row came from the basic machine-readable material (MRM)  tape:

 N    No
 Y    Yes
G


© Copyright IBM Corp.