Re: Read access to informix tables

From: d_choo@hotmail.com > >i am trying to do sql query from a informix table via dbacess. However >i realised that records in this table are often >exclusively lock by other users when they are doing a data entry or >update to the table. the sql will be unsuccessful if the table is being >updated with error 107 - the record is being locked. > >any ideas as what can be done to the sql. i dun care what the data is >prior or after commit, i just need some kind of info from the table. > >my sql look something like this: > >select sum(t_alloc),sum(t_ordr) from inventory; Try: SET ISOLATION TO DIRTY READ;SELECT SUM(t_alloc), SUM(t_ordr) FROM inventory; Have a peek at isolation levels in the manuals at http://www.informix.com/answers/ ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com