The FLG.COMMENTS table contains all the comments on objects in the Information Catalog Manager information catalog.
At any time, this table may contain zero to many rows.
The INSTIDNT column is the primary key of the table.
The NAME, CREATOR, and CREATSTP columns form the unique index of the table.
The NAME, CREATOR, CREATSTP, and UPDATIME columns are indexes of the table.
Table 63 provides information about each column found in the
FLG.COMMENTS table.
Table 63. FLG.COMMENTS table column properties
| Column name | Data type | Description | Nullable | NLS |
|---|---|---|---|---|
| OBJTYPID | CHAR(6) | This six-digit object type ID, generated by the Information Catalog Manager, represents a specific object type in the information catalog. | No | SBCS |
| INSTIDNT | CHAR(10) | The unique instance ID generated by the Information Catalog Manager. It is the second part of the FLGID, the 10-digits serial number that will uniquely identify this instance within its own object type. | No | SBCS |
| NAME | VARCHAR(80) | The name entered by the information catalog user to identify each user-defined object instance. | No | Both SBCS and DBCS |
| UPDATIME | CHAR(26) | The date and time of the metadata creation or last update. This date is generated by the Information Catalog Manager. | Yes | None |
| UPDATEBY | CHAR(8) | The user ID of the information catalog administrator who last updated the instance. | Yes | Both SBCS and DBCS |
| CREATOR | CHAR(8) | The creator of the Comments object. The system will set the creator value to the current user ID. | No | Both SBCS and DBCS |
| CREATSTP | CHAR(26) | A timestamp indicating the date and time the Comments object instance was created. This timestamp is supplied by the system when the instance is created. | No | None |
| STATUS | CHAR(80) | The status of the comment. Users can design their own conventions for this value. | Yes | Both SBCS and DBCS |
| ACTIONS | VARCHAR(250) | Specifies what action the user should take. | Yes | Both SBCS and DBCS |
| EXTRA | VARCHAR(80) | Used for extra information. | Yes | Both SBCS and DBCS |
| Note:
NLS: National Language Support SBCS: Single Byte Character Set DBCS: Double Byte Character Set | ||||