The 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.