The EXIT_PROGRAM_INFO view returns information about exit programs.
The values returned for the columns in the view are closely related to the values returned by the Work with Registration Information (WRKREGINF) CL command and by the Retrieve Exit Information (QUSRTVEI, QusRetrieveExitInformation) API.
Authorization: None required.
The following table describes the columns in the view. The system name is EXIT_PGM. The schema is QSYS2.
|Column Name||System Column Name||Data Type||Description|
|EXIT_POINT_NAME||EXIT_NAME||VARCHAR(20)||The exit point name.|
|EXIT_POINT_FORMAT||EXIT_FMT||CHAR(8)||The exit point format name associated with the exit point.|
|REGISTERED||REGISTERED||VARCHAR(3)||Whether the exit point is registered with the registration facility.
|COMPLETE||COMPLETE||VARCHAR(3)||Whether the information returned for the exit point is complete and
accurate. Incomplete information may occur when the exit point's retrieve preprocessing program
indicates that the information it returned is incomplete or inaccurate.
|EXIT_PROGRAM_NUMBER||NUMBER||INTEGER||The exit program number associated with the exit program. This number determines the processing sequence of exit programs associated with an exit point, where the lowest number is processed first.|
|EXIT_PROGRAM_LIBRARY||LIBRARY||VARCHAR(10)||The library in which EXIT_PROGRAM resides.|
|EXIT_PROGRAM||PROGRAM||VARCHAR(10)||The name of the exit program.|
|The descriptive text for the exit program .
Contains the null value if no descriptive text is available.
|The data that is associated with the exit program.
Contains the null value when there is no exit program data.
|The coded character set identifier (CCSID) to use for working with
the exit program data.
Contains the null value when EXIT_PROGRAM_DATA is null.
|The thread safety status of the exit program entry.
Contains the null value when the threadsafe status of the exit program entry is not known.
|MULTITHREADED_JOB_ACTION||JOB_ACTION||VARCHAR(6)||The action to take when calling an exit program in a multithreaded
|QMLTTHDACN_SYSTEM_VALUE||QMLTTHDACN||VARCHAR(3)||Indicates whether the QMLTTHDACN system value was used in
determining the multithreaded job action.
- List all the exit programs associated with security exit
SELECT * FROM QSYS2.EXIT_PROGRAM_INFO WHERE EXIT_POINT_NAME LIKE 'QIBM_QSY%' ORDER BY EXIT_POINT_NAME, EXIT_PROGRAM_NUMBER;