VIEWS 

Use

This table contains all the view tables for which the current user has privileges.

Structure

VIEWS

OWNER

CHAR(32)

Name of the owner of the view table

VIEWNAME

CHAR(32)

Name of the view table

PRIVILEGES

CHAR(30)

Privileges of the user for the view table

TYPE

CHAR(8)

Type of table

CREATEDATE

DATE

Creation date of the view table

CREATETIME

TIME

Creation time of the view table

UPDSTATDATE

DATE

Date at which the UPDATE STATISTICS statement was last carried out on the view table

UPDSTATTIME

TIME

Time at which the UPDATE STATISTICS statement was last carried out on the view table

ALTERDATE

DATE

Alter date of the view table

ALTERTIME

TIME

Alter time of the view table

UNLOADED

CHAR(3)

View table is unloaded (YES | NO)

COMMENT

LONG

Comment on the view table

 

Integration

System tables