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 256 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 text and may contain newline characters.
Column Name
Data Type
Description
table_name
char(256)
The view name. Must be a valid Ingres name.
table_owner
char(32)
The view owner’s Ingres username.
view_dml
char(8)
The language in which the view was created: S (for SQL).
check_option
char(8)
Y if the check option was specified in the create view statement, or N if not. Set to blank if unknown.
text_sequence
integer
The sequence number for the text field, starting with 1.
text_segment
varchar(256)
The text of the view definition.
 
Last modified date: 12/14/2023