DB2 Universal Database for iSeries SQL Reference

SYSVIEWDEP

The SYSVIEWDEP view records the dependencies of views on tables, including the views of the SQL catalog. The following table describes the columns in the SYSVIEWDEP view:

Table 134. SYSVIEWDEP view

Column name System Column Name Data Type Description
VIEW_NAME DNAME VARCHAR(128) Name of the view. This is the SQL view name if it exists; otherwise, it is the system view name.
VIEW_OWNER DCREATOR VARCHAR(128) Owner of the view
OBJECT_NAME ONAME VARCHAR(128) Name of the object the view is dependent on.
OBJECT_SCHEMA OSCHEMA VARCHAR(128) Name of the SQL schema that contains the object the view is dependent on.
OBJECT_TYPE OTYPE CHAR(24) Type of object the view was based on:

FUNCTION
Function

MATERIALIZED QUERY TABLE
The object is a materialized query table.

TABLE
Table

TYPE
Distinct Type

VIEW
View
VIEW_SCHEMA DDBNAME VARCHAR(128) Name of the schema of the view.
SYSTEM_VIEW_NAME SYS_VNAME CHAR(10) System View name
SYSTEM_VIEW_SCHEMA SYS_VDNAME CHAR(10) System View schema
SYSTEM_TABLE_NAME SYS_TNAME CHAR(10)
Nullable
System Table name.

Contains the null value if the object is a function or distinct type.

SYSTEM_TABLE_SCHEMA SYS_DNAME CHAR(10)
Nullable
System Table schema.

Contains the null value if the object is a function or distinct type.

TABLE_NAME BNAME VARCHAR(128)
Nullable
Name of the table or view the view is dependent on. This is the SQL view name if it exists; otherwise, it is the system view name.

Contains the null value if the object is a function or distinct type.

TABLE_OWNER BCREATOR VARCHAR(128)
Nullable
Owner of the table or view the view is dependent on.

Contains the null value if the object is a function or distinct type.

TABLE_SCHEMA BDBNAME VARCHAR(128)
Nullable
Name of the SQL schema that contains the table or view the view is dependent on.

Contains the null value if the object is a function or distinct type.

TABLE_TYPE BTYPE CHAR(1)
Nullable
Type of object the view was based on:

T
Table

P
Physical file

M
Materialized query table

V
View

L
Logical file

Contains the null value if the object is a function or distinct type.

IASP_NUMBER IASPNUMBER SMALLINT Specifies the independent auxiliary storage pool (IASP) number.
PARM_SIGNATURE SIGNATURE VARCHAR(10000)
Nullable
This column identifies the routine signature.

Contains the null value if the object is not a routine.


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