>empnam,empno, typ1,total_cfil
>a       1     20    1
>a       1     20    3 
>a       1     20    1
>a       1     20    2
>a       1     18    10 
>a       1     18    32
>b
>b
>c
>c
>..
>..
>***********************
>i need result from table mucurtw to new table or cursor sum typ1 and count typ1 it all fields is CHR type as..
>empnam,empno, typ1,newtotal_cfil,count1
>a      1      20      7            4
>a      1      18      42           2
>.
>.
>
>

SELECT empnam, empno, typ1, ;
               CAST(SUM(total_cfil)  AS C(20)) as Newtotal_cfil, ;
               CAST(CNT(*) AS C(20))AS count1 ;
  FROM mucurtw ;
  GROUP BY empnam, empno, typ1 ;
  INTO CURSOR csrResult