SELECT_SQL EXAMPLE using Group_by and Count(*)

SELECT_SQL FIELDS(#AGENT #ACCTNO (#ZZCNT ‘COUNT(*)’)) FROM_FILES((DWXP010)) WHERE(‘CANDTE = 0 AND AGENT =:ZAGENT’) GROUP_BY(‘AGENT,ACCTNO’) IO_ERROR(*NEXT)