C. Standard Catalog Interface : Catalogs : The iimulti_locations Catalog
 
Share this page                  
The iimulti_locations Catalog
For tables located on multiple volumes, this table contains an entry for each additional location on which a table resides. The first location for a table can be found in the iitables catalog.
Note:  Ingres Star does not currently populate this table.
This table is keyed on table_name and table_owner:
Column Name
Data Type
Description
table_name
char(256)
The table name. Must be a valid name.
table_owner
char(32)
The table’s owner. Must be a valid username.
sequence
integer
The sequence of this location in the list of locations, as specified in the modify statement. This is numbered from 1.
location_name
char(32)
The name of the location.