TimeStamp – Code400

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!!! 123456SELECT 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

using QWCCVTDT to get UTC time

UTC time can be used when queuing data. In a project where you have data sent external from the IBM i to AWS (Amazon Cloud Services). This data is sent via webservice on the IBM i using HTTPS post and