The FLG.OVERDESC table contains all long description properties. Each long description is divided into 3-KB chunks.
The OBJTYPID, INSTIDNT, PHYPRPNM, and SEQNO columns form the primary key of table FLG.OVERDESC.
Table 68 provides information about each column found in the
FLG.OVERDESC table.
Table 68. FLG.OVERDESC 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, represents a specific object type in the information catalog. | No | SBCS |
| INSTIDNT | CHAR(10) | The unique instance ID generated by the Information Catalog Manager. The ID is the second part of the FLGID, the 10-digit portion of the serial number that uniquely identifies this instance within its own object type. | No | SBCS |
| PHYPRPNM | CHAR(8) | The original property or column name defined by the user. | No | SBCS |
| SEQNO | SMALLINT | A sequence number to keep track of how many rows reflect the same incoming source. | No | None |
| ODESC | VARCHAR(3000) | This entry keeps the segments of a long description, which can be up to 32700 bytes, in a smaller and more manageable buffer. | No | Both SBCS and DBCS |
| Note:
NLS: National Language Support SBCS: Single Byte Character Set DBCS: Double Byte Character Set | ||||