SYSTEM_VALUE_INFO view
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.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
SYSTEM_VALUE_NAME | SYSVALNAME | VARCHAR(10) | Name of the system value. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
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. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]()
![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]()
![]() |
![]() ![]() |
![]() ![]() |
![]() VARGRAPHIC(3840)
CCSID(1200) ![]() |
![]() ![]() |
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