Re: Read access to informix tables
Use set isolation to dirty read before your SQL statement.
This isolation will get you to read a record even though it locked.
I hope it will help you.
bob@null.com on 07/04/2000 06:27:52 AM
Please respond to bob@null.com
To: informix-list@iiug.org
cc: (bcc: Rao Yalamanchili/APS)
Subject: Re: Read access to informix tables
Suggestion, try setting your lock mode, for example
set lock mode to wait;
select ...
In article <8jrvft$qra$1@nnrp1.deja.com>, d_choo@hotmail.com says...
> 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;