Re: SQL code -246, ISAM code -154 problem.

On Wed, 22 Jan 1997 15:53:49 -0500, Peter Jennings <peter_jennings*@uk.ibm.com> wrote: >Peter Jennings wrote: >> >> Running OnLine V5.0 under AIX. >> We have a begin/commit process that locks a >> parent record by updating a column with its >> current contents. We find that if two users >> try to update different rows in the same child >> table, the first will suceed and the other fail >> with SQL code -246, ISAM code -154. >> The two users are accessing different rows >> in both the parent and the child tables. >> This only happens if the first user has not >> reached the 'commit' before the second user >> trys to update. >> Both the tables have row mode locking set. /snip/ Have considered using row mode locking? I dont't know if Informix 5 can do this, Informix 7 sure can. You have to tell Informix to do so, otherwise it defaults to page mode locking. In most case, several records can fit onto 1 page. When 1 record of the page is locked, the whole page is locked. Koen Van der Elst Systems Engineer