execute block returns (txt varchar(10)) as declare variable i int=1; begin while (i<10) do begin txt=case i when 1 then 'Eins' when 2 then 'Zwei' when 3 then 'Drei' else '>3' end; i=i+1; suspend; end end