Was this helpful?
iiregistrations Catalog
The iiregistrations catalog contains the text of register statements, and is used by Ingres Star and Enterprise Access products.
Column Name
Data Type
Description
object_name
char(256)
The name of the registered table, view, or index.
object_owner
char(32)
The name of the owner of the table, view, or index.
object_dml
char(1)
The language used in the registration statement. S for SQL or Q for QUEL.
object_type
char(2)
Describes the object type of object_name. The values are T if the object is a table, V if it is a view, or I if it is an index.
object_subtype
char(1)
Describes the type of table or view created by the register statement. For Ingres Star, this will be L (link). For an Enterprise Access product, this will be I (imported object).
text_sequence
integer8
The sequence number of the text field, numbered from 1.
text_segment
varchar(240)
The text of the register statement.
Last modified date: 01/30/2023