The FLG.PROGRAMS table is used to keep track of all program objects in the information catalog.
The INSTIDNT column is the primary key of the table FLG.PROGRAMS.
The UUICLASS, UUIQUAL1, UUIQUAL2, UUIQUAL3, and UUIDENT columns form the unique index of table FLG.PROGRAMS.
The NAME, UPDATEBY, UPDATIME, UUICLASS, UUIQUAL1, UUIQUAL2, UUIQUAL3, UUIDENT, and HANDLES columns are indexes of the table.
Table 70 provides information about each column found in the
FLG.PROGRAMS table.
Table 70. FLG.PROGRAMS table column properties
| Column name | Data type | Description | Origin | NLS |
|---|---|---|---|---|
| OBJTYPID | CHAR(6) | The six-digit object type ID, generated by the Information Catalog Manager, represents a specific object type. | 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-digit serial number that uniquely identifies this instance within its own object type. | No | SBCS |
| NAME | VARCHAR(80) | This name is 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 metadata creation or last update. This is generated by the Information Catalog Manager. | Yes | SBCS |
| UPDATEBY | CHAR(8) | The user ID of the information catalog administrator who last updated the instance. | Yes | Both SBCS and DBCS |
| UUICLASS | CHAR(25) | The part1 name of the universal unique identifier (UUI). | No | Both SBCS and DBCS |
| UUIQUAL1 | VARCHAR(48) | The part2 name of the (UUI). | No | Both SBCS and DBCS |
| UUIQUAL2 | VARCHAR(48) | The part3 name of the (UUI). | No | Both SBCS and DBCS |
| UUIQUAL3 | VARCHAR(48) | The part4 name of the (UUI). | No | Both SBCS and DBCS |
| UUIDENT | VARCHAR(70) | The part5 name of the (UUI). | No | Both SBCS and DBCS |
| HANDLES | CHAR(8) | The object type that this program handles. | Yes | SBCS |
| STARTCMD | VARCHAR(250) | The program name to be invoked. The program can have an extension of .exe, .cmd, .com, or .bat. | No | Both SBCS and DBCS |
| PARMLIST | VARCHAR(1800) | If a parameter list is required to handle object instances, the value of the parameter is specified by the HANDLES property. | Yes | Both SBCS and DBCS |
| SHRTDESC | VARCHAR(250) | The short description of the program. | Yes | Both SBCS and DBCS |
| Note:
NLS: National Language Support SBCS: Single Byte Character Set DBCS: Double Byte Character Set | ||||