SYSTEM_VALUE_INFO view

The SYSTEM_VALUE_INFO view contains information about system values.

This view returns the names of system values and their values. The list of system values can be found in Retrieve System Values (QWCRSVAL) API.

*ALLOBJ or *AUDIT special authority is required to retrieve the values for QAUDCTL, QAUDENDACN, QAUDFRCLVL, QAUDLVL, QAUDLVL2, and QCRTOBJAUD. The current value column will contain ‘*NOTAVL’ or -1 when accessed by an unauthorized user.

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

Table 1. SYSTEM_VALUE_INFO view
Column Name System Column Name Data Type Description
SYSTEM_VALUE_NAME SYSVALNAME VARCHAR(10) Name of the system value.
CURRENT_NUMERIC_VALUE CURNUMVAL BIGINT Contains the value if the system value is numeric data. Otherwise, contains the null value.
CURRENT_CHARACTER_VALUE CURCHARVAL

VARGRAPHIC(1280)
CCSID(1200)

Contains the value if the system value is character data. Otherwise, contains the null value.

Example

Look at the system values related to maximums.

SELECT * FROM SYSTEM_VALUE_INFO       
WHERE SYSTEM_VALUE_NAME LIKE '%MAX%' 
returns
 SYSTEM_VALUE_NAME  CURRENT_NUMERIC_VALUE   CURRENT_CHARACTER_VALUE 
   QMAXACTLVL                    32,767      -         
   QMAXSIGN                            -     000005    
   QPWDMAXLEN                         8      -         
   QMAXSGNACN                          -     3         
   QMAXJOB                      163,520      -         
   QMAXSPLF                       9,999      -