begin work;

create temp table ttt ( a char, b char ) with no log;
insert into ttt ( a ) values ( 'a' );
insert into ttt ( a ) values ( 'b' );

create procedure ttt( )
define v char;
foreach select distinct a into v from ttt
on exception in ( -206 ) end exception with resume;
if v = 'a' then
create temp table aaa_bbb ( f int ) with no log;
end if;
update ttt set b = v where a = v;
drop table aaa_bbb;
end foreach;
end procedure;

execute procedure ttt( );

Oops!

Any comments?

--
Áåñïëàòíûé ïî÷òîâûé ÿùèê ïðåäîñòàâëåí http://pasts.delfi.lv
sending to informix-list