Re: Concurrent Table Access

In article <6ovt0k$192$1@nnrp1.dejanews.com>, greg.carter@workmail.com wrote: > With Informix Online Dynamic Server 7.22 and above, what is the best > technique to use which will allow multiple users running multiple update > transactions and queries against the same table to have concurrent access to > that table, including having visibility to the most recently committed > changes? > > We would like especially to avoid the situation whereby updates from > transactions that begin and commit within the scope of a larger transaction > are hidden until the larger transaction commits. > > Thanks, > G.Carter > mailto:greg.carter@homemail.com > mailto:greg.carter@workmail.com > http://www.webaccess.net/~greg.carter > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum > Try to set an isolation level for reading. To supply these levels, Online uses shared locks. Shared locks let other processes read rows but not update them. Pablo F Herrero -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum