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.
Murray Wood — — source: Informix-list mailing list archive (1991-1998)
set lock mode to wait
Murray Wood
-----Original Message-----
From: Perv [SMTP:null@millsandallen.com]
Sent: Tuesday, April 27, 1999 9:01 AM
To: informix-list@iiug.org
Subject: Dirty read on SCO
Subject: Dirty read on SCO
Problem: 4gl programs crash with 'row locked' despite having dirty read
set.
I have encountered this problem running on SCO and Version 7.22 of the
engine. At the start of each program I set isolation to dirty read and
never reset to any other value. All tables have row level locks. A query
on a set of rows will yield the following error
SQL statement error number -243.
Could not position within a table (informix."tabname").
SYSTEM error number -144.
The problem is not so pronounced if I place another dirty read set just
before the offending line, but its hell to do this everywhere - surely
the initial setting should be held.
The same code seems to work fine under HPUX.
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.