sql db2 as400

-- conta i record su as400 in base
SELECT P2DAP, P2STR, COUNT (*) FROM ugsd00/p2preno8
WHERE
P2DAP > 20060100 and p2dap < 20070299
and p2str LIKE 'LB800%'
GROUP BY P2DAP , P2STR