EXIT_PROGRAM_INFO view

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.

Table 1. EXIT_PROGRAM_INFO view
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. NO The exit point is unregistered. YES The exit point is registered.
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. NO The exit point entry information is not complete or accurate. The remaining columns should be ignored. YES The exit point entry information is complete and accurate.
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.
TEXT_DESCRIPTION	TEXT	VARCHAR(132) Nullable	The descriptive text for the exit program . Contains the null value if no descriptive text is available.
EXIT_PROGRAM_DATA	DATA	VARCHAR(2048) Nullable	The data that is associated with the exit program. Contains the null value when there is no exit program data.
EXIT_PROGRAM_DATA_CCSID	DATA_CCSID	INTEGER Nullable	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.
THREADSAFE	THREADSAFE	VARCHAR(3) Nullable	The thread safety status of the exit program entry. NO The exit program entry is not threadsafe. YES The exit program entry is threadsafe. 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 job. MSG Run the exit program in the current multithreaded job, but send an informational message. CPI3C80 can be used as the informational message. NORUN Do not run the exit program in the current multithreaded job. Depending on the exit point, do one of the following: Send an escape message and do not call the exit program. CPF3C80 can be used as the escape message. Send an informational message and do not call the exit program. CPF3C80 can be used as the informational message. Call the exit program in a non-multithreaded job. *RUN Run the exit program in the current multithreaded job.
QMLTTHDACN_SYSTEM_VALUE	QMLTTHDACN	VARCHAR(3)	Indicates whether the QMLTTHDACN system value was used in determining the multithreaded job action. NO The QMLTTHDACN system value was not used to determine the multithreaded job action. YES The QMLTTHDACN system value was used to determine the multithreaded job action.

Example

List all the exit programs associated with security exit points.

SELECT *
  FROM QSYS2.EXIT_PROGRAM_INFO 
  WHERE EXIT_POINT_NAME LIKE 'QIBM_QSY%'
  ORDER BY EXIT_POINT_NAME, EXIT_PROGRAM_NUMBER;