A. System Catalogs : Extended System Catalogs : Catalogs Shared by All Ingres Tools : ii_objects Catalog
 
Share this page                  
ii_objects Catalog
The ii_objects catalog contains a row for every user interface object in the database. This catalog stores basic information about each object, such as name, owner, object ID, object class, and creation date.
Objects in this table often have additional information represented in rows of one or more other user interface catalogs; for example, form objects are also represented by rows in ii_forms, ii_fields, and ii_trim. In all cases, the object ID is the key column that is used to join information from multiple catalogs about a single object.
The ii_objects catalog is a btree table, keyed on the object_class, object_owner, and object_name columns. The ii_objects catalog has a secondary index, btree unique, keyed on the object_id column:
Column Name
Data Type
Description
object_id
integer
The object identifier, unique among user interface objects in the database.
object_class
integer
The object's class. Tells what type of object this is (form, report, and so on). For object class definitions, see Object Classes in the ii_objects Catalog (see page Object Classes in the ii_objects Catalog).
object_name
varchar(32)
The name of the object.
object_owner
varchar(32)
The object owner's user name.
object_env
integer
Currently unused.
is_current
smallint
Currently unused.
short_remark
varchar(60)
A short descriptive remark associated with the object.
object_language
smallint
Currently unused.
create_date
char(25)
The time and date when the object was initially created.
alter_date
char(25)
The time and date when the object, or associated information, was most recently altered or saved.
alter_count
integer
A count of the number of times this object has been altered or saved.
last_altered_by
varchar(32)
The name of the user who last altered or saved this object.
Object Classes in the ii_objects Catalog
Object class is a column in the ii_objects catalog. Each object class is as follows:
Object Class
Description
1002
JoinDef
1501
Generic Report
1502
Report-Writer Report
1511
RBF Report
1601
Form
2001
ABF Application
2010
4GL Intermediate Language Code
2021
Host Language Procedure
2050
4GL Procedure
2075
Database Procedure
2110
Global Variable
2120
Constant
2130
Record Definition
2133
Record Attribute
2190
Undefined Procedure
2201
QBFName
2210
4GL Frame
2219
Old 4GL Frame
2220
Report Frame
2230
QBF Frame
2249
GBF Frame
2250
Undefined Frame
2260
Vision menuframe
2261
Vision append frame
2262
Vision update frame
2264
Vision browse frame
3001
ABF Form Reference
3501
Dependency Type: member of
3502
Dependency Type: database reference
3503
Dependency Type: call with no use of return code
3504
Dependency Type: call with use of return code