LIBRARY_LIST_INFO view

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

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