zOs/SQL/GBGRSCHW

select *
    from oa1p.TQZ008GBGRSCHWHIST
    where dbSys = 'DBOF' and db = '%' and dsMin = 16
    order by validbegin desc
;x;
-- überprüfte
--    welche s
--
--
set current path oa1p;
select tsTy || case when ix = ' --ts--' then ' ts' else ' ix' end tsTy
      , substr(fosFmte7(limGb), 1, 7) "limGb"
      , substr(fosFmte7(real(limGb / 100 * schwelle)), 1, 7) "schwGb"
      , schwelle
      , count(*) count
      , min(schwInfo) schwInfoMin
      , max(schwInfo) schwInfoMax
    from OA1P.vQZ006GbGrenze
    where -- actGb > real(limGb / 100 * schwelle)
        db like '%'
        and db <> 'DSNDB01'  -- directory ist anders
        and rz = 'RZ2' and dbSys = 'DBOF'
    group by tsTy || case when ix = ' --ts--' then ' ts' else ' ix' end
                 , limGb, schwelle
    order by 1, schwelle desc, limGb desc