zOs/SQL/WACHSTUM

set current path oa1p;
with sDay as
( select
datum
,sum(hi_u_rba) as b
, row_number() over (order by datum) row
from OA1P.TADM09A1
where DB_NAME LIKE 'NI02A1P%'
and TS_NAME LIKE 'A250A%'
and datum >= Date ('01.03.2010')
and datum <= Date ('21.06.2010')
group by datum
)
select dayofWeek(h.Datum), h.datum,
        fOsFmtE7(h.b - g.b) "wachs",
        fOsFmtE7(h.b) "heute", -- h.row,
        fOsFmtE7(g.b) "gest", g.datum
    from sDAy h
        left join sDAy g
        on h.row = g.row+1
;
x;
sInt as
( select
max(datum) as datum
,max(b) as b
from sDay
group by floor(days(datum) / 1)
),
sMax as
( select max(b) as b
from sDay )
select
datum
, sInt
,DEC(sInt.b,15,2) / 1024 / 1024 as mbytes
,DEC(sInt.b,15,0) / 1024 / 1024 / 1024 as gbytes
,repeat('*', int(round(sInt.b * 40 / sMax.b, 0))) as grafik
from sInt, sMax
order by datum desc