RE: SQL Counts

Glad to see that someone at Kronos is trying something new!!!  Now let's see...

by SQL group what exactly do you mean??

Thanks,
Tommy


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Boman, James
Sent: Wednesday, July 13, 2005 2:21 PM
To: RPG programming on the AS400 / iSeries
Subject: SQL Counts


Does anyone know if it is possible to perform multiple counts within one
/EXEC SQL group? If it is possible, does someone have an example they
would share with me?

 

See example of single select below:

 

C/EXEC SQL                                                       

C+    SELECT COUNT(*) INTO:RECORDS FROM CKEMPLLA WHERE EEAC01='Y'

C/END-EXEC                                                       

 

 

TIA