zOs/SQL/PVSVER
select ldatum, count(*)
from oa1t.vpv013a1a
where lDatum between '20050601' and '20050677'
group by lDatum;
-- select
-- char(mon) || ', ' ||arbid || ', ' || char(sum(erstPag#))
-- || ', ' || char(sum(erstCou#)) || ', ' || char(count(*))
-- from
-- ( select
-- year(ldatum) * 100 + month(lDatum) as mon,
-- left(erstJob,4) arbid, erstPag#, erstCou#
-- from oa1t.vpv013a1a
-- where left(erstJob,2) in ('BE', 'CD', 'CS', 'ED')
-- and year(ldatum) = 2005 and month(lDatum) = 3
-- ) t1
-- group by arbid , mon
-- order by arbid , mon ;
--
-- select
-- mon as "Month", arbid as "ArbID", sum(erstPag#) as "Pages",
-- sum(erstCou#) as "Documents", count(*) as "Count"
-- from
-- ( select
-- year(ldatum) * 100 + month(lDatum) as mon,
-- left(erstJob,4) arbid, erstPag#, erstCou#
-- from oa1t.vpv013a1a
-- where year(ldatum) = 2005 and month(lDatum) = 3
-- ) t1
-- group by arbid , mon
-- order by arbid , mon ;