BINDING_DIRECTORY_INFO view

The BINDING_DIRECTORY_INFO view returns information about the object entries in binding directories.

The values returned for the columns in the view are similar to the values returned by the Display Binding Directory (DSPBNDDIR) CL command

Authorization: The caller must have:

*USE authority to the library containing the binding directory, and
*OBJOPR and *READ authority to the binding directory.

To return the create timestamp for a binding directory entry, the caller must have:

*EXECUTE authority to the library containing the binding directory entry, and
Some authority to the binding directory entry.

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

Table 1. BINDING_DIRECTORY_INFO view
Column Name	System Column Name	Data Type	Description
BINDING_DIRECTORY_LIBRARY	BNDDIR_LIB	VARCHAR(10)	The library containing the binding directory.
BINDING_DIRECTORY	BNDDIR	VARCHAR(10)	The binding directory name.
ENTRY_LIBRARY	ENTRY_LIB	VARCHAR(10)	The library containing ENTRY. Can contain the special value *LIBL.
ENTRY	ENTRY	VARCHAR(10)	The name of the binding directory entry.
ENTRY_TYPE	ENTRY_TYPE	VARCHAR(7)	The object type of the binding directory entry. MODULE The object is a module. SRVPGM The object is a service program.
ENTRY_ACTIVATION	ENTRY_ACT	VARCHAR(6) Nullable	The activation control of the bound service program. DEFER Activation of the bound service program may be deferred until a function it exports is called. IMMED Activation of the bound service program takes place immediately when the program or service program it is bound to is activated. Contains the null value if ENTRY_TYPE is *MODULE.
ENTRY_CREATE_TIMESTAMP	ENTRY_TS	TIMESTAMP(0) Nullable	The timestamp when the object was created. Contains the null value if the entry timestamp is not available.

Examples

Return a list of the entries for all binding directories in library TESTLIB that start with 'TEST'.

SELECT * FROM QSYS2.BINDING_DIRECTORY_INFO
    WHERE BINDING_DIRECTORY_LIBRARY = 'TESTLIB'
          AND BINDING_DIRECTORY LIKE 'TEST%'
    ORDER BY BINDING_DIRECTORY_LIBRARY,
             BINDING_DIRECTORY,
             ENTRY_LIBRARY,
             ENTRY;

List all of the binding directories that have the entry MYLIB/HELLO, type *MODULE.

SELECT BINDING_DIRECTORY,
       BINDING_DIRECTORY_LIBRARY
    FROM QSYS2.BINDING_DIRECTORY_INFO    
    WHERE ENTRY = 'HELLO'
          AND ENTRY_LIBRARY = 'MYLIB'
          AND ENTRY_TYPE = '*MODULE'
    ORDER BY 1, 2;