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)

This entry was posted on 29. May 2008 at 14:37 and is filed under LANSA. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response or trackback from your own site.