A data area can be used whenever you need to store information of limited size, independent of the existence of procedures or files. Typical uses of data areas are: To provide an area (perhaps within each job’s QTEMP library) to
Using SQL to retrieve system information
List system values that contain “SEC” in the name. Take some time and play with the SQL — Become famous Post new samples!!! SELECT SYSTEM_VALUE_NAME as sysvalue, ifnull(CURRENT_NUMERIC_VALUE,0) as DecValue, CURRENT_CHARACTER_VALUE as CharValue FROM SYSTEM_VALUE_INFO where SYSTEM_VALUE_NAME LIKE ‘%SEC%’ this