SELECT char(datum, iso), char(datum, jis), char(datum, eur),
ERSTJOB, PVSJOB, SUM(ERSTPAG#)
FROM oa1t.VPV013A1A
WHERE DATUM >= '27.07.2005' AND
PVSJOB LIKE 'PVS%'
GROUP BY DATUM, ERSTJOB, PVSJOB, DATUM
order BY DATUM, ERSTJOB, PVSJOB, DATUM;