Re: Stored Procedures, CURSOR
julio@jatoba.cpd.ufop.br wrote:
>
> How cam I do a DELETE FROM table WHERE CURRENT OF locktable
> on a SP
>
> Where locktable is a declared CURSOR FOR UPDATE
>
> HELP!
>
> Thanks.
> julio@cpd.ufop.br
Hi Julio,
are you looking for the declaration of a CUROSOR FOR UPDATE in SPL ?
If I understand your question correctly, here's the answer:
foreach LOCKTABLE for select * from table
...
delete from table WHERE CURRENT OF LOCKTABLE;end foreach;
Bye,
Stefan.
stefan@weideneder.de
PS: RTFM, "Informix Guide to SQL: Syntax 7.1 Page 2-22" ;-))