Tabelas SYSIBM - SYSIBM.SYSPACKDEP

SYSIBM.SYSPACKDEP

Records the dependencies of packages on local tables, views, synonyms, table spaces, indexes, and aliases.

Nome da coluna	Tipo de dados	Descrição	Uso
BNAME	VARCHAR(18) NOT NULL	The name of an object that a package depends on.	G
BQUALIFIER	CHAR(8) NOT NULL	If BNAME identifies a table space, the name of its database. Otherwise, the authorization ID of the owner of BNAME.	G
BTYPE	CHAR(1) NOT NULL	Type of object identified by BNAME and BQUALIFIER: A Alias I Index P Partitioned table space R Table space S Synonym T Table V View	G
DLOCATION	CHAR(16) NOT NULL	Always contains blanks	S
DCOLLID	CHAR(18) NOT NULL	Name of the package collection	G
DNAME	CHAR(8) NOT NULL	Name of the package	G
DCONTOKEN	CHAR(8) NOT NULL	Consistency token for the package. This is either: ° The "level" as specified by the LEVEL option when the package's program was precompiled ° The timestamp indicating when the package's program was precompiled, in an internal format.	S
IBMREQD	CHAR(1) NOT NULL	Whether the row came from the basic machine readable material (MRM) tape: N No Y Yes	G