Re: Update not updating
Peter Wages wrote:
>
> On our production box, an HP9000 with version 7 of Informix, we have a
> situation where after a program attempts to do an insert into a table and
> discovers the record already exists, the program attempts to do an update.
> The update returns a sqlcode of zero and a sqlerrd record count of zero
> records updated. One record should have been updated.
>
> We cant seem to duplicate the situation on our development box, also an
> HP9000 version 7 of Informix.
>
> This doesn't seem to be a commit problem. Any ideas?
>
> Thanks very much.
>
> ciao
> p
>
> ******************************************************************************
> Peter Wages
> EDS Arlington, Virginia
> pmwages@cais.com
> Work: (703) 741-7436 Home: (202) 244-3511
> Anywhere is walking distance, if you have the time
> ******************************************************************************
Hi Peter,
how do you prevent the following situation ?
(P1) (P1) (P2) (P1)
insert into gets the deletes try to perform
table duplicate that an update, but
error row the row is deleted
|-----|--------------|------------|-------------|-----------------> t
P1 := Process 1
P2 := Process 2
If there is no second process, and/or if your program does not start
a second process, the situation is odd.
Thanks for a short reply,
Stefan.
stefan@weideneder.de