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.
IBM Informix Dynamic Server Version 11.70.UC4IE
if i leave out the order by the spl works.. so
i guess order by is not allowed...??
create procedure tessie ()
define i int;
define f_lname like customer.lname;
define f_customer_num int;
foreach mycurr for select customer_num, lname into f_customer_num,
f_lname
from customer order by customer_num
update customer set lname = "x"|| trim (lname )
where current of mycurr;
end foreach;
end procedure;
execute procedure tessie(); 365: Cursor must be on simple SELECT for FOR UPDATE.
Workaround would be:
create procedure tessie ()
define i int;
define f_lname like customer.lname;
define f_customer_num int;
foreach select customer_num, lname into f_customer_num, f_lname
from customer order by customer_num
update customer set lname = "x"|| trim (lname )
where customer_num = f_customer_num;
end foreach;
end procedure;
execute procedure tessie();
but that could cause deadlocks if one is not carefull...
one more, are there any plans to put the case statement from xps into
IDS??
comments are welcome
Superboer.
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.