Re: Select for update in SPL

Posted in 2004

Curtis Crowson — 7 Sep 2004 07:05:08 -0700 — source: Usenet: comp.databases.informix

Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<wP0_c.1865$N4.1371@newsread3.news.pas.earthlink.net>... > 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. No, "with hold" is also valid in SPL. But I don't think it does what we want it to.