SQL Reference

SYSCAT.VIEWS

Contains one or more rows for each view that is created.

Table 96. SYSCAT.VIEWS Catalog View

Column Name Data Type Nullable Description
VIEWSCHEMA VARCHAR(128)
Name of the view or the name of a table used to define a summary table.
VIEWNAME VARCHAR(128)
DEFINER VARCHAR(128)
Authorization ID of the creator of the view.
SEQNO SMALLINT
Always 1.
VIEWCHECK CHAR(1)
States the type of view checking:

N = No check option
L = Local check option
C = Cascaded check option

READONLY CHAR(1)

Y = View is read-only because of its definition.
N = View is not read-only.

VALID CHAR(1)

Y = View or summary table definition is valid.
X = View or summary table definition is inoperative; must be re-created.

QUALIFIER VARCHAR(128)
Contains value of the default schema at the time of object definition.
FUNC_PATH VARCHAR(254)
The SQL path of the view creator at the time the view was defined. When the view is used in data manipulation statements, this path must be used to resolve function calls in the view. SYSIBM for views created before Version 2.
TEXT CLOB(64k)
Text of the CREATE VIEW statement.

Column Name	Data Type	Description
VIEWSCHEMA	VARCHAR(128)	Name of the view or the name of a table used to define a summary table.
VIEWNAME	VARCHAR(128)
DEFINER	VARCHAR(128)	Authorization ID of the creator of the view.
SEQNO	SMALLINT	Always 1.
VIEWCHECK	CHAR(1)	States the type of view checking: N = No check option L = Local check option C = Cascaded check option
READONLY	CHAR(1)	Y = View is read-only because of its definition. N = View is not read-only.
VALID	CHAR(1)	Y = View or summary table definition is valid. X = View or summary table definition is inoperative; must be re-created.
QUALIFIER	VARCHAR(128)	Contains value of the default schema at the time of object definition.
FUNC_PATH	VARCHAR(254)	The SQL path of the view creator at the time the view was defined. When the view is used in data manipulation statements, this path must be used to resolve function calls in the view. SYSIBM for views created before Version 2.
TEXT	CLOB(64k)	Text of the CREATE VIEW statement.

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

[ DB2 List of Books | Search the DB2 Books ]