>CREATE CURSOR testsub (date1 d(8),sno n(2),icode n(2),weight n(2)) >INSERT INTO testsub VALUES ({^2007/01/01},1,5,10) >INSERT INTO testsub VALUES ({^2007/01/01},3,7,20) >INSERT INTO testsub VALUES ({^2007/01/01},3,7,30) >INSERT INTO testsub VALUES ({^2007/01/02},1,3,40) >INSERT INTO testsub VALUES ({^2007/01/02},2,3,50) >INSERT INTO testsub VALUES ({^2007/01/02},1,3,60) >INSERT INTO testsub VALUES ({^2007/01/03},1,8,70) >>I want to scan
SELECT date1,sno,icode,SUM(weight) as weight FROM testsub INTO CURSOR tmp1 GROUP BY 1,2,3 SELECT date1,CNT(sno),CNT(icode),SUM(weight) FROM tmp1 INTO CURSOR tmp2 GROUP BY 1