Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.