Administration Guide

SYSCAT.FUNCDEP

Each row represents a dependency of a function on some other object.

Table 78. SYSCAT.FUNCDEP Catalog View

Column Name Data Type Nullable Description
FUNCSCHEMA VARCHAR(128)
Qualified name of the function which has dependencies on another object.
FUNCNAME VARCHAR(18)
BTYPE CHAR(1)
Type of object that the function is dependent on.

A = Alias
F = Function instance
O = Privilege dependency on all subtables or subviews in a table or view hierarchy
R = Structured type
S = Summary table
T = Table
U = Typed table
V = View
W = Typed view
X = Index extension

BSCHEMA VARCHAR(128)
Qualified name of the object that the function has a dependency on.
BNAME VARCHAR(128)
TABAUTH SMALLINT Yes If BTYPE = O, S, T, U, V or W then it encodes the privileges on the table or view that are required by the dependent function. Otherwise null.

Column Name	Data Type	Nullable	Description
FUNCSCHEMA	VARCHAR(128)		Qualified name of the function which has dependencies on another object.
FUNCNAME	VARCHAR(18)
BTYPE	CHAR(1)		Type of object that the function is dependent on. A = Alias F = Function instance O = Privilege dependency on all subtables or subviews in a table or view hierarchy R = Structured type S = Summary table T = Table U = Typed table V = View W = Typed view X = Index extension
BSCHEMA	VARCHAR(128)		Qualified name of the object that the function has a dependency on.
BNAME	VARCHAR(128)
TABAUTH	SMALLINT	Yes	If BTYPE = O, S, T, U, V or W then it encodes the privileges on the table or view that are required by the dependent function. Otherwise null.

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

[ DB2 List of Books | Search the DB2 Books ]