zOs/SQL/MATUSE

set current refresh age = any;
select current refresh age from sysibm.sysdummy1;
    SELECT NI920001
       , NI920002
       , NI920003
       , COUNT(*) COUNT
       , SUM(CASE WHEN NI920005 ='U' THEN 1 ELSE 0 END) URVRS
       , SUM(CASE WHEN NI920005 ='S' THEN 1 ELSE 0 END) SRVS
       , SUM(CASE WHEN NI920005 ='E' THEN 1 ELSE 0 END) ERRS
       , SUM(CASE WHEN NI920005 ='W' THEN 1 ELSE 0 END) WARNS
       , SUM(CASE WHEN NI920005 ='I' THEN 1 ELSE 0 END) INFOS
       FROM gdb0237.TNI920A101A
         WHERE NI920001='20070511'
       GROUP BY NI920001
       , NI920002
       , NI920003
;