Start of change

BOUND_SRVPGM_INFO view

The BOUND_SRVPGM_INFO view returns information about service programs bound into an ILE program or service program.

The values returned for the columns in the view are closely related to the values returned for *SRVPGM detail on the DSPPGM (Display Program) and DSPSRVPGM (Display Service Program) CL commands and the List ILE Program Information (QBNLPGMI) and the List Service Program Information (QBNLSPGM) APIs.

Authorization: The caller must have:
  • *USE authority to the program or service program, and
  • *EXECUTE authority to the library containing the program or service program.

The following table describes the columns in the view. The system name is SRVPGM_INF. The schema is QSYS2.

Table 1. BOUND_SRVPGM_INFO view
Column Name System Column Name Data Type Description
PROGRAM_LIBRARY PGM_LIB VARCHAR(10) Library containing the program or service program.
PROGRAM_NAME PGM_NAME VARCHAR(10) Program or service program name.
OBJECT_TYPE OBJ_TYPE VARCHAR(7) Object type for PROGRAM_NAME.
*PGM
A program.
*SRVPGM
A service program.
BOUND_SERVICE_PROGRAM_LIBRARY BDSRVPGMLB VARCHAR(10) The name of the library containing the service program bound to PROGRAM_NAME at bind time. This is the library name in which the activation expects to find the service program at run time. Can contain the following special value:
*LIBL
Indicates the library list is used at the time the service program is needed.
BOUND_SERVICE_PROGRAM BDSRVPGM VARCHAR(10) The name of the service program bound to PROGRAM_NAME.
BOUND_SERVICE_PROGRAM_SIGNATURE SIGNATURE BINARY(16) The current signature of the service program at the time the service program was bound to PROGRAM_NAME.
BOUND_SERVICE_PROGRAM_ACTIVATION SRVPGM_ACT VARCHAR(6) Specifies when the bound service program is activated.
*DEFER
The bound service program activation is deferred until a procedure it exports is called.
*IMMED
The bound service program activation happens when PROGRAM_NAME is activated.

Example

  • Examine whether service programs in APPLIB are taking advantage of deferred service program activation.
    SELECT BOUND_SERVICE_PROGRAM_ACTIVATION, COUNT(*) AS BOUND_SERVICE_PROGRAM_ACTIVATION_COUNT
      FROM QSYS2.BOUND_SRVPGM_INFO
      WHERE PROGRAM_LIBRARY = 'APPLIB'
      GROUP BY BOUND_SERVICE_PROGRAM_ACTIVATION
      ORDER BY 2 DESC;
End of change