Use the information in the CIU_PROGRAM_DETAIL table to write your own SQL applications to query the tables; these applications must use native SQL queries.
Field Name | Type | Description |
---|---|---|
COLLECTION_ID | CHAR(16) | Collection ID. |
ARCHIVE_DATE | TIMESTAMP | Time of archiving. |
APPLID | CHAR(8) | CICS region applid. |
HOMESYSID | CHAR(4) | SYSID of local region. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
PROGRAM_NAME | CHAR(8) | Name of the program resource. |
LINKEDIT_DATE | TIMESTAMP | Reserved for future use. |
LIB_NAME | CHAR(8) | Name of the library resource from which this program was loaded. |
LIB_DATASET-NAME | CHAR(44 | Name of the data set from which the program was loaded. |
ACCESS | CHAR(8) | The type of storage into which the program is loaded. Values are: CICS, USER, READONLY, and NONE. |
APIST | CHAR(8) | Indicates the API attribute of the installed program definition. Values are: CICSAPI and OPENAPI. |
CONCURRENCY | CHAR(12) | Indicates the concurrency attribute of the installed program definition. Values are: QUASIRENT and THREADSAFE. |
DATA_LOCATION | CHAR(10) | Indicates whether this program can accept data address higher than 16 MB. Values are: ANY, BELOW, and NOTAPPLIC. |
DYNAMIC_STATUS | CHAR(10) | Indicates if the program is the subject of a program-link request; that is, the request can be dynamically routed. Values are: DYNAMIC and NOTDYNAMIC. |
EXECUTION_KEY | CHAR(10) | Indicates the storage key of the program. Values are: CICS, USER, and NOTAPPLIC. |
EXECUTION_SET | CHAR(10) | Indicates whether the program is restricted to the distributed program link subset of the CICS API. Values are: DPLSUBSET, FULLAPI, and NOTAPPLIC. |
HOLD_STATUS | CHAR(10) | Indicates how long the program is to remain loaded. Values are: CICSLIFE, TASKLIKE, and NOTAPPLIC. |
INSTALL_TYPE | CHAR(10) | Indicates the method used to install the program resource definition. Values are: AUTO, CATALOG, GROUPLIST, MANUAL, RDO, and SYSAUTO. |
LANGUAGE_DEDUCED | CHAR(12) | Indicates the language deduced by CICS for the program. Values are: ASSEMBLE, C370, COBOL, COBOL2, LE370, PLI, Java™, NOTDEDUCED, and NOTAPPLIC. |
LANGUAGE_DEFINED | CHAR(12) | Indicates the programming language specified on the resource definition. Values are: ASSEMBLE, C370, COBOL, LE370, PLI, NOTDEFINED, and NOTAPPLIC. |
LOAD_STATUS | CHAR(12) | Indicates whether the program can be loaded. Values are: LOADABLE, NOTLOADABLE, NOTLOADED, and NOTAPPLIC. |
LOCATION | CHAR(8) | Indicates where the most recently loaded copy of the program resides. Values are: CDSA, ECDSA, ELPA, ERDSA, ESDSA, LPA, RDSA, SDSA, and NONE |
MODULE_TYPE | CHAR(12) | Indicates the type of this program resource. Values are: MAPSET, PARTITIONSET, and PROGRAM. |
PROGRAM_ATTRIBUTE | CHAR(10) | Indicates the residency status of the program. Values are: RELOAD, RESIDENT, REUSABLE, TRANSIENT, and TEST. |
PROGRAM_LENGTH | INTEGER | The length of the program in bytes. |
PROGRAM_TYPE | CHAR(10) | Indicates where the next new copy of the program is to be loaded from. Values are: PRIVATE, SHARED, TYPEANY, and NOTAPPLIC. |
PROGRAM_USAGE | CHAR(12) | Indicates whether the program is used as a CICS nucleus program or as a user application program. Values are: APPLICATION or NUCLEUS. |
REMOTE_DEFINITION | CHAR(8) | Indicates whether this program is a local or a remote resource. Values are: LOCAL or REMOTE. |
REMOTE_PROGID | CHAR(8) | The name by which this program is known in the remote CICS region. |
REMOTE_SYSID | CHAR(4) | The name of the remote CICS region that owns the program. |
REMOTE_TRANID | CHAR(4) | The name of the transaction under which the program runs on the remote CICS region. |
SPECIFIED_AMODE | CHAR(12) | The addressing mode specified for the resource. Values are: AMODE24, AMODE31, AMODEANY, and NOTSPECIFIED. |
SPECIFIED_RMODE | CHAR(12) | The residency mode specified for the resource. Values are: RMODE24, RMODE31, RMODEANY, and NOTSPECIFIED. |
FIRST_RUN | TIMESTAMP | Time of first occurrence, in the local time format. |
LAST_RUN | TIMESTAMP | Time of latest observation, in the local time format. |