SQL Stored Procedure

[mk]

Hallo zusammen

so klappt es:

...
...                                                
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION       
  Begin                                         
   set IO_Code=SQLCODE ;                        
  End;
...
..
 drop table mk/stpsum  ;                      
    set IO_Code='001'   ;                     
    set io_Msg  = 'table delete ' ;           
                                              
 create table mk/stpsum                       
    as(  select grp as GRPSUM,                
          dec( sum(QTY) , 10 , 0) as SumQty , 
          dec( sum(AMT) , 10 , 2) as SumAMt   
     FROM mk/stp GROUP BY grp)                
     with  data   ;                           
                                              
    set IO_Code='002'   ;                     
    set io_Msg  = 'table erstellt ' ; 

Dieses Forum und die fachliche Kompetenz ist einfach Spitze

Vielen Dank