Re: Locking

If no operations are modifying data in the database, or if there are and you don't really care, you can use the statement "SET ISOLATION TO DIRTY READ;" to bypass any locks. If a row is locked, the original values will be retrieved. Wang, Tong wrote in message <6qvohj$ff6$1@news.xmission.com>... > >At the start of transaction, use the "set lock mode to wait.." to change >the behavior when table locked(default-return the error code 244 and >return immediately.). And not lock a table too long in one transaction. >Thanks! > >tong wang >(650)432 7862 > >> ---------- >> From: Thomas Ronzon[SMTP:Thomas.Ronzon@quantum.de] >> Sent: Wednesday, August 12, 1998 1:15 AM >> To: informix-list@iiug.org >> Subject: Locking >> >> Hi >> >> I have an Informix Database running on SINIX/Reliant Unix. >> The problem is the locking. >> When a user starts isql no other user can access the database. >> >> Where can I change it, so that several users can access the db ?? >> >> Thomas Ronzon >> >> Thomas.Ronzon@quantum.de >>