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:

*EXECUTE authority to the library containing the program or service program, and
*READ authority to 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;