Start of change

EXIT_POINT_INFO view

The EXIT_POINT_INFO view returns information about exit points.

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_POINT. The schema is QSYS2.

Table 1. EXIT_POINT_INFO view
Column Name System Column Name Data Type Description
EXIT_POINT_NAME EXIT_NAME VARCHAR(20) The name of the exit point.
EXIT_POINT_FORMAT EXIT_FMT CHAR(8) The 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.
ALLOW_DEREGISTRATION DEREGISTER VARCHAR(3) Whether the exit point can be deregistered.
NO
The exit point cannot be deregistered.
YES
The exit point can be deregistered.
ALLOW_CHANGE CHANGE VARCHAR(3) Whether the exit point controls can be changed.
NO
The exit point controls cannot be changed.
YES
The exit point controls can be changed.
EXIT_PROGRAMS EXIT_PGMS INTEGER The current number of exit programs associated with the exit point.
MAXIMUM_EXIT_PROGRAMS MAX_PGMS INTEGER
Nullable
 The maximum number of exit programs that the exit point allows.

Contains the null value if the maximum number of exit programs is *NOMAX.
TEXT_DESCRIPTION TEXT VARCHAR(132)
Nullable
 The descriptive text for the exit point.

Contains the null value if no descriptive text is available.
ADD_EXIT_PROGRAM_LIBRARY ADD_LIB VARCHAR(10)
Nullable
 The library in which ADD_EXIT_PROGRAM resides.

Contains the null value if no add exit program is defined.
ADD_EXIT_PROGRAM ADD_PGM VARCHAR(10)
Nullable
 The preprocessing exit program name that is called by the registration facility when the Add Exit Program API is called for the exit point.

Contains the null value if no add exit program is defined.
ADD_EXIT_PROGRAM_FORMAT ADD_FMT CHAR(8)
Nullable
 The format name for ADD_EXIT_PROGRAM.

Contains the null value if no add exit program is defined.
REMOVE_EXIT_PROGRAM_LIBRARY RMV_LIB VARCHAR(10)
Nullable
 The library in which REMOVE_EXIT_PROGRAM resides.

Contains the null value if no remove exit program is defined.
REMOVE_EXIT_PROGRAM RMV_PGM VARCHAR(10)
Nullable
 The preprocessing exit program name that is called by the registration facility when the Remove Exit Program API is called for the exit point.

Contains the null value if no remove exit program is defined.
REMOVE_EXIT_PROGRAM_FORMAT RMV_FMT CHAR(8)
Nullable
 The format name for REMOVE_EXIT_PROGRAM.

Contains the null value if no remove exit program is defined.
RETRIEVE_EXIT_PROGRAM_LIBRARY RTV_LIB VARCHAR(10)
Nullable
 The library in which RETRIEVE_EXIT_PROGRAM resides.

Contains the null value if no retrieve exit program is defined.
RETRIEVE_EXIT_PROGRAM RTV_PGM VARCHAR(10)
Nullable
 The preprocessing exit program name that is called by the registration facility when the Retrieve Exit Information API is called for the exit point.

Contains the null value if no retrieve exit program is defined.
RETRIEVE_EXIT_PROGRAM_FORMAT RTV_FMT CHAR(8)
Nullable
 The format name for RETRIEVE_EXIT_PROGRAM.

Contains the null value if no retrieve exit program is defined.

Example

  • List all the security exit points.
    SELECT *
  FROM QSYS2.EXIT_POINT_INFO
  WHERE EXIT_POINT_NAME LIKE 'QIBM_QSY%';
End of change