The FLG.OBJTYREG table is used to keep track of all objects and their object types, as well as tables created by the Information Catalog Manager.
The OBJTYPID column is the primary key of FLG.OBJTYREG that uniquely identifies an object type in the information catalog and is used as the prefix for all instance IDs.
The columns PTNAME, NAME, and DPNAME are unique index keys of the FLG.OBJTYREG table.
The columns CATEGORY, CREATOR, and UPDATEBY are index keys of the table.
Table 67 provides information about each column found in the
FLG.OBJTYREG table.
Table 67. FLG.OBJTYREG table column properties
| Column name | Data type | Description | Nullable | NLS |
|---|---|---|---|---|
| OBJTYPID | CHAR(6) | The six-digit object type ID generated by the Information Catalog Manager. The ID represents a specific object type in the information catalog. | No | SBCS |
| PTNAME | CHAR(30) | The name of the object type. The name is also used as the name of the user's table. The actual size of PTNAME is determined by the value of ENVSIZE on the FLG.PARMS table, which is defined during installation. | No | SBCS |
| DPNAME | CHAR(8) | The unique object type name within an information catalog. | No | SBCS |
| NAME | VARCHAR(80) | The external name of this object type. | No | Both SBCS and DBCS |
| CATEGORY | CHAR(1) | The Information Catalog Manager categories: Elemental E, Grouping G, Program P, Contact C, Dictionary D, Support S, and Attachment A. | No | SBCS |
| CREATOR | CHAR(8) | The user ID of the information catalog administrator who created the object type. It will be blank when the object type is registered. It will also contain a blank after the object type is deleted but before the registration is removed. | Yes | Both SBCS and DBCS |
| UPDATIME | CHAR(26) | The date and time of the object type that was created or that had its properties extended. | Yes | SBCS |
| UPDATEBY | CHAR(8) | The user ID of the information catalog administrator who last extended the object type (appended properties). | Yes | Both SBCS and DBCS |
| LASTINID | INTEGER | The last system-generated instance ID for this object type.
This is an internal property, and it will not be visible to the information catalog user. It is accessed and updated by the Create Instance IPI only. | No | None |
| OBJICON | LONG VARCHAR FOR BIT DATA | The icon bitmap corresponding to the object type. | No | None |
| Note:
NLS: National Language Support SBCS: Single Byte Character Set DBCS: Double Byte Character Set | ||||