Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.