SYSTEM_VALUE_INFO view

Edit online

The SYSTEM_VALUE_INFO view contains information about system values.

The values returned for the columns in the view are closely related to the values returned by the Display System Value (DSPSYSVAL) CL command. The complete list of system values can be found in Retrieve System Values (QWCRSVAL) API.

Authorization: The caller must have *ALLOBJ or *AUDIT special authority to retrieve the values for QAUDCTL, QAUDENDACN, QAUDFRCLVL, QAUDLVL, QAUDLVL2, and QCRTOBJAUD. The value of *NOTAVL or -1 is returned when accessed by an unauthorized user.

The following table describes the columns in the view. The system name is SYSVALINFO. 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.
Start of changeSYSTEM_VALUEEnd of change Start of changeSYSVALEnd of change Start of changeVARGRAPHIC(3840) CCSID(1200) End of change Start of changeContains the formatted system value.End of change
CURRENT_NUMERIC_VALUE CURNUMVAL BIGINT
Nullable
 Contains the value if the system value is numeric data. Otherwise, contains the null value.
CURRENT_CHARACTER_VALUE CURCHARVAL
VARGRAPHIC(3840)
CCSID(1200) Nullable
 Contains the value if the system value is character data. Otherwise, contains the null value.
Start of changeTEXT_DESCRIPTIONEnd of change Start of changeTEXTEnd of change Start of changeVARCHAR(50)End of change Start of changeText that describes the system value. End of change
Start of changeCATEGORYEnd of change Start of changeCATEGORYEnd of change Start of changeVARCHAR(7)End of change Start of changeThe type of system value.
*ALC
Allocation
*DATTIM
Date and time
*EDT
Editing
*LIBL
Library list
*MSG
Message and logging
*SEC
Security
*STG
Storage
*SYSCTL
System control
End of change
Start of changeCHANGEABLEEnd of change Start of changeCHANGEABLEEnd of change Start of changeVARCHAR(3)End of change Start of changeWhether the system value can be changed with the Change System Value (CHGSYSVAL) CL command.
NO
The system value cannot be changed.
YES
The system value can be changed.
End of change
Start of changeSHIPPED_DEFAULT_VALUEEnd of change Start of changeDEFAULTEnd of change Start of change
VARGRAPHIC(3840)
CCSID(1200)
End of change		 Start of changeThe default value that is shipped for the system value.End of change

Example

Look at the system values related to maximums and their system shipped defaults..

SELECT SYSTEM_VALUE_NAME, SYSTEM_VALUE, SHIPPED_DEFAULT_VALUE FROM QSYS2.SYSTEM_VALUE_INFO       
WHERE SYSTEM_VALUE_NAME LIKE '%MAX%';
returns
 SYSTEM_VALUE_NAME  SYSTEM_VALUE   SHIPPED_DEFAULT_VALUE
   QMAXACTLVL       *NOMAX          *NOMAX   
   QMAXSIGN         10              3   
   QPWDMAXLEN       128             8
   QMAXSGNACN       3               3
   QMAXJOB          163520          163520  
   QMAXSPLF         9999            9999