SELECT_SQL EXAMPLE using Group_by and Count(*)

29. May 2008 by admin.

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

Posted in LANSA | No Comments »