LIBRARY_LIST_INFO view

The LIBRARY_LIST_INFO view contains information about the current job's library list.

The information returned is similar to the detail available through the DSPLIBL (Display Library List) CL command.

Authorization: None required.

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

Table 1. LIBRARY_LIST_INFO view
Column Name System Column Name Data Type Description
ORDINAL_POSITION COLNO INTEGER Position of this entry in the library list.
SCHEMA_NAME NAME VARCHAR(128)
Nullable
Name of the schema.
SYSTEM_SCHEMA_NAME SYS_NAME VARCHAR(10) System name of the schema.
TYPE TYPE VARCHAR(15) The portion of the library list containing the selected library. Possible values are:
USER
The library is in the user portion of the library list.
SYSTEM
The library is in the system portion of the library list.
PRODUCT
The library is a product library in the library list.
CURRENT
The library is the current library entry in the library list.
IASP_NUMBER IASP SMALLINT
Nullable
The number of the auxiliary storage pool where storage is allocated for the library.
TEXT_DESCRIPTION TEXT VARGRAPHIC(50) CCSID 1200
Nullable
The text description of the library.

Contains the null value is there is no text description.

Example

  • See the current library list for your job
    SELECT * FROM QSYS2.LIBRARY_LIST_INFO