OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Standard Catalogs > Standard Catalog Interface > iiregistrations Catalog
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: 04/03/2024