SQL - SYSIBM.SYSPLANDEP - 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.SYSPLANDEP
Records the dependencies of plans on tables, views, aliases, synonyms, table spaces, and indexes.

Nome da coluna Tipo de dados Descrição Uso
 BNAME  VARCHAR(18) NOT NULL  Name of an object the plan is dependent on. G
 BCREATOR  CHAR(8) NOT NULL  If BNAME is a table space, its database. Otherwise, the authorization ID  of the owner of BNAME. G
 BTYPE  CHAR(1) NOT NULL  Type of object BNAME:

 A    Alias
 I     Index
 P    Partitioned table space
 R    Table space
 S    Synonym
 T    Table
 V    View		 G
 DNAME  CHAR(8) NOT NULL  Name of the plan. G
 IBMREQD  CHAR(8) NOT NULL  Whether the row came from the basic machine-readable material (MRM) tape:

 N    No
 Y    Yes 		G

© Copyright IBM Corp.