-565 (-111)
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