OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Standard Catalogs > Standard Catalog Interface > iiviews Catalog
Was this helpful?
iiviews Catalog
The iiviews catalog contains one or more entries for each view in the database (views are indicated in iitables by table type = “V”). Because the text_segment column is limited to 240 characters per row, a single view can require more than one row to contain all its text. In this case, the text will be broken in mid-word across the sequenced rows. The text column is pure text, and can contain newline characters.
Column Name
Data Type
Description
table_name
char(256)
The view name. Must be a valid object name.
table_owner
char(32)
The view owner's user name.
view_dml
char(1)
The language in which the view was created: S (for SQL) or Q (for QUEL).
check_option
char(1)
Contains Y if the check option was specified in the create view statement, N if not, or blank if unknown.
text_sequence
integer8
The sequence number for the text field, starting with 1.
text_segment
varchar(240)
The text of the view definition.
Last modified date: 01/30/2023