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      -