7. Understanding Ingres Star Catalogs : Ingres Star Catalogs : Standard Catalogs
 
Share this page                  
Standard Catalogs
The standard catalogs let you get information from the system catalogs, which cannot be queried directly. For details on the standard catalogs, see the appendix "Standard Catalog Interface."
Important!  Users and user applications can query the standard catalogs but cannot update them.
The standard catalogs provided with the current release are identical in specification and function to the Ingres 2.6 standard catalogs, except as noted in the following table:
Catalog Name
Exceptions to Release 2.6 Catalog
iialt_columns
None
iicolumns
None
iidbcapabilities
Has the additional entries: OWNER_NAME, STANDARD_CATALOG_LEVEL, OPEN/SQL_LEVEL, DB_DELIMITED_CASE, and DB_REAL_USER_CASE.
iidbconstants
Has the added column system_owner
iihistograms
None
iiindexes
None
iiindex_columns
None
iiintegrities
iimulti_locations
iipermits
Not used. Ingres Star does not support permits or integrities. For multiple locations, partitioning across several locations is managed by the autonomous local database server.
You can query these catalogs, but Ingres Star never populates them with data, so your answer will always be a null set of rows. If you want permit, integrity or location information about a registered object, do a direct connect to the appropriate local database and query the local database’s standard catalogs.
iiphysical_tables
None
iiprocedures
None
iiregistrations
None
iiregistered_objects
An Ingres Star-only standard catalog
iistats
Has the added columns: column_domain, is_complete, stat_version, hist_data_length.
iitables
Column location name is 32 bytes long, not 24.
iiviews
None