It depends on the x in your 4.1x code, but assuming you've got a reasonably
recent version, you should find SACEISOL and SPERISOL or SPERFISOL
documented in the release notes. These allow you to set the isolation
levels (not lock mode) for Ace and Perform respectively. In case of doubt,
use lower case letters and a single space between the words, and no leading
or trailing spaces; early versions were very fussy, later ones are more
tolerant.
eg. export SACEISOL="dirty read"
What do you mean, you aren't using a Korn Shell so the above syntax doesn't
work? It's the only civilized shell... :-)
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>
}From: vfraenkle@aol.com (VFraenkle)
}Date: 10 Sep 1996 18:07:02 -0400
}X-Informix-List-Id: <news.27923>
}
}My problem:
}
}I use SQL Development 4.1 on a Informix 5.0C?? Database.
}My written ace-report runs very nice, but when there is a lock ...
}Then it is as a roulette ... somtimes ace returned the same record (the
}record, bevore the locked record) 1000 times.
}
}My Questions:
}
}Is it possible to set the lockmode to dirty read?
}Are there any bugfixes of the problem below?
}Other ideas?
}
}thanks volker