IBM Books

Administration Guide

OBJCAT.PACKAGEDEP

Contains a row for each dependency that packages have on indexes, tables, views, functions, aliases, types, and hierarchies.

Table 112. OBJCAT.PACKAGEDEP Catalog View
Column Name Data Type Nullable Description
PKGSCHEMA CHAR(8)
Name of the package.
PKGNAME CHAR(8) 
BINDER


CHAR(8)


Yes


Binder of the package.


BTYPE


CHAR(1)




Type of object BNAME: 

    

  • A=alias

  • F=function-instance

  • H=table or view hierarchy

  • I=index

  • R=structured type

  • S=summary table

  • T=table

  • V=view




BSCHEMA
CHAR(8)


Qualified name of an object on which the package is dependent.

BNAME
VARCHAR(18)





TABAUTH





SMALLINT





Yes





If BTYPE is T(table) or V(view),
encodes the privileges that are
required by this package (Select, Insert, Delete, Update).






Note:

    

  1. When a depended-on function-instance is dropped, the package is placed
into an "inoperative" state from which it must be explicitly
rebound. When any other depended-on object is dropped, the package is
placed into an "invalid" state from which the system will attempt to
rebind it automatically when a package is first referenced.









[ Top of Page | Previous Page | Next Page | Table of Contents | Index ] 


[ DB2 List of Books |
Search the DB2 Books ]