Re: Select for update in SPL
Posted in 2004
Topics: Stored Procedures & SPL
Hi folks
Why not user WITH HOLD ?
FOREACH cursor1 WITH HOLD FOR
select colname , colname1 .... from tablename, tablename1 ....
where ....
BR
R Ferronato
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:<cgpltn$3qv$1@news.xmission.com>...
> Boris Niyazov said:
> > Thanks June. You're right!
>
> June's right? Wow. What a surprise.
>
> :o)
>
> --
> Bye now,
> Obnoxio
>
> "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
> - Coluche
>
> "I'm trying to see things your way, but I can't get my head up my ass"
> - JCH
>
> "Ogni uomo mi guarda come se fossi una testa di cazzo"
> - Marco
>
> http://www.catb.org/~esr/faqs/smart-questions.html
> sending to informix-list
Ferronato wrote:
> Why not user WITH HOLD ?
> FOREACH cursor1 WITH HOLD FOR
> select colname , colname1 .... from tablename, tablename1 ....
> where ....
Because that is I4GL syntax and not SPL syntax.
> "Obnoxio The Clown" <obnoxio@serendipita.com> wrote:
>>Boris Niyazov said:
>>
>>>Thanks June. You're right!
>>
>>June's right? Wow. What a surprise.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/