DBPedias

All your database knowledge are belong to you

DB2 zOS

SYSIBM.SYSVIEWS (V8)

Description: Contains one or more rows for each view, materialized query table, or user-defined SQL function.

Tablespace: SYSVIEWS

Indexes(Fields):
DSNVVX01(CREATOR.NAME.SEQNO.TYPE)

Column name Description Data type
NAME Name of the object.
NOT NULL
CREATOR Authorization ID of the owner of the object.
NOT NULL
SEQNO Sequence number of this row; the first portion of the view is on row one and successive rows have increasing values of SEQNO.
NOT NULL
CHECK Whether the WITH CHECK OPTION clause was specified in the CREATE VIEW statement: ; N
No
C
Yes with the semantic
Y
Yes with the semantic

The value is N if the view has no WHERE clause, or the object is not a view.


NOT NULL
IBMREQD A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
NOT NULL
TEXT Text or portion of the text of the statement that was used to create the object.
NOT NULL
PATHSCHEMAS SQL path at the time the object was defined. The path is used to resolve unqualified data type and function names used in the object definition.
NOT NULL WITH
DEFAULT
RELCREATED Release of DB2 that was used to create the object: ; blank
Created prior to Version 7.
K
Created on Version 7

NOT NULL WITH
DEFAULT
TYPE Type of table: ; F
SQL function
M
Materialized query table
V
View

NOT NULL
REFRESH Refresh mode: ; D
A materialized query table with a deferred refresh mode
blank
Not a materialized query table

NOT NULL WITH
DEFAULT
ENABLE Indicates whether query optimization is enabled: ; Y
Enabled
N
Disabled
blank
Not a materialized query table

NOT NULL WITH
DEFAULT
MAINTENANCE Maintenance mode: ; S
For a REFRESH = D, a materialized query table that is maintained by the system.
U
For a REFRESH = D, a materialized query table that is maintained by the user.
blank
Not a materialized query table.

NOT NULL WITH
DEFAULT
REFRESH_TIME For REFRESH = D and Maintenacne = S, the timestampl of the REFRESH TABLE statement that last refreshed the data. Otherwise, this is the default timestamp ('0001-01-01.00.00.00.000000').
NOT NULL WITH
DEFAULT
ISOLATION Isolation level when the materialized query table is created or altered from a base table: ; R
RR (repeatable read)
S
CS (cursor stability)
T
RS (read stability)
U
UR (uncommitted read)
blank
Not a materialized query table

NOT NULL WITH
DEFAULT
SIGNATURE Contains an internal description. Used for materialized query tables.
NOT NULL WITH
DEFAULT
FOR BIT DATA
APP_ENCODING_CCSID CCSID of the current application encoding scheme at the time the object was created. For objects created prior to Version 8 of DB2, the value is 0.
NOT NULL WITH
DEFAULT

Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).

Retrieved from "http://dbpedias.com/w/index.php?title=DB2_zOS:SYSIBM.SYSVIEWS_(V8)&oldid=22068"