The FLG.PROPERTY table is used to define a property for an object type. There is one row for each property of each object type defined in this table. For a description of Information Catalog Manager object types and object type properties, see Information Catalog Manager object types.
The OBJTYPID column is the index of the table.
Table 71 provides information about each column found in the
FLG.PROPERTY table.
Table 71. FLG.PROPERTY table column properties
| Column name | Data type | Description | Nullable | NLS |
|---|---|---|---|---|
| OBJTYPID | CHAR(6) | System-generated ID that is a unique 6 digits for each object type. | No | SBCS |
| PHYPRPNM | CHAR(8) | The physical name of the property in the object type. This name will be used to generate the column name in the user's object table. | No | SBCS |
| PROPNAME | VARCHAR(80) | The external name of this object type property. | No | Both SBCS and DBCS |
| DATATYPE | CHAR(30) | Property data type, CHAR, VARCHAR, LONG VARCHAR and TIMESTAMP. | No | SBCS |
| LENGTH | INTEGER | Property length. | No | None |
| OPTIONS | CHAR(1) | A value flag used to indicate if this field allows null values.
| No | SBCS |
| UUISEQNO | CHAR(1) | The UUI sequence number of the property in the object type. | Yes | SBCS |
| PROPSEQ | INTEGER | The sequence number of the property | No | None |
| Note:
NLS: National Language Support SBCS: Single Byte Character Set DBCS: Double Byte Character Set | ||||