SQL Reference

SYSCAT.FUNCDEP

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

Table 57. SYSCAT.FUNCDEP Catalog View

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

A = Alias
F = Function instance or method 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 depended on by the function or method (if BTYEPE='F', this is the specific name of a function).
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 or the dependent method. Otherwise null.

Column Name	Data Type	Nullable	Description
FUNCSCHEMA	VARCHAR(128)		Qualified name of the function or name of the method which has dependencies on another object.
FUNCNAME	VARCHAR(18)
BTYPE	CHAR(1)		Type of object that the function or method is dependent on. A = Alias F = Function instance or method 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 depended on by the function or method (if BTYEPE='F', this is the specific name of a function).
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 or the dependent method. Otherwise null.

[ Top of Page | Previous Page | Next Page ]