Re: SELECT...FOR UPDATE

That is correct. Both of those options are illegal with "for update". In general, both of those can require temp tables, which don't work well with "for update". Vic marianat@my-dejanews.com wrote: > I'm working with an Informix OnLine Dynamic Server 7.30, and an ODBC driver. > I need to know if it is possible to have a SQL query like this: > > select * from <table> order by <field> for update;> > According to the messages I'm getting, this is not possible: the "select...for > update" clause is rejected when you use order by or group by. > Is this correct? > > Thanks, > Mariana. > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own -- Vic Goldberg Manager, DBA Team, Acting Manager, Technical Integration Cornell University (607) 254-7441 (Voice) (607) 255-6982 (Fax)