A. System Catalogs : Extended System Catalogs : Catalogs Shared by All Ingres Tools : ii_longremarks Catalog
 
Share this page                  
ii_longremarks Catalog
The ii_longremarks catalog contains the “long remarks” text associated with user interface objects. Only those objects that have an associated long remark are entered in this catalog. Consequently, unless all objects being selected have a long remark entered, joins between ii_objects and ii_longremarks must be outer joins. For an example of an outer join between the ii_objects and ii_longremarks catalogs, see Sample Queries for the Extended System Catalogs for SQL (see page Sample Queries for the Extended System Catalogs for SQL). The current implementation restricts long remarks to a single row; the sequence column is provided for a future enhancement to allow remarks of arbitrary length.
The ii_longremarks catalog is structured as btree unique on the object_id and remark_sequence columns:
Column Name
Data Type
Description
object_id
integer
Object ID of the user interface object this remark belongs to. Various other information about this object (such as name, owner and object class) is kept in the ii_objects catalog.
remark_sequence
integer
A sequence number for (future) representation of multiple segments of text comprising one object's long remarks.
long_remark
varchar(600)
The long remarks text associated with the object.
remark_language
integer
Currently unused.