Was this helpful?
iiregistered_ objects Catalog
The iiregistered_objects catalog is an Ingres Star-only catalog. It resides in all distributed databases, but is not available in local databases. This catalog ties registered objects that Ingres Star may acquire when the user registers a table to the underlying objects in the local database. The registered objects are tables, views, secondary indexes, and procedures.
Column Name
Data Type
Description
ddb_object_name
char(256)
The name of the Ingres Star-registered object. Must be a valid name.
ddb_object_owner
char(32)
The name of the owner of the Ingres Star-registered object. Must be a valid username.
register_date
char(25)
The date the object was registered. This is a date field.
ldb_database
char(32)
The name of the local database in which the registered object resides.
ldb_node
char(32)
The node on which the ldb_database resides.
ldb_dbmstype
char(32)
The type of the ldb_database. These are the same types used by iinamu (INGRES, RMS, DB2, RDB, and so on).
ldb_object_name
char(256)
The name that the local database uses for the registered object.
ldb_object_owner
char(32)
The name of the owner of the registered object in the local database.
ldb_object_type
char(8)
The type of local object. The values are T if the object is a table, V if it is a view, I if the object is an index, or P if the object is a procedure.
Last modified date: 04/03/2024