a Loop around the reads/writes to check the On
Error value.
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Anmol Chandrakant Khopade
Sent: 20 July 2005 00:01
To: u2-users@listserver.u2ug.org
Subject: [U2] DATABASE write problem
Hi,
I
A known cause of UV error 040019 (my guess for Anmol is
Variation-on-the-Theme #2):
When processA is holding the update lock on a record,
and processB issues a WRITE to that record,
then processB will wait for the lock for 20 minutes (non-configurable),
then abort or take ON ERROR clause with
Jerry,
I alwys like this sort of a protection against overwriting:
100BASE.ID = 'ZZZ' : '.' : DATE() : '.' : TIME() : '.'
101DONE = FALSE
102TIEBREAKER = 1
103LOOP
104 READU DUMMY FROM BASE.FILE, BASE.ID : TIEBREAKER LOCKED
105
.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Key Ally
Sent: Wednesday, July 20, 2005 10:30 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] DATABASE write problem
Jerry,
I alwys like this sort of a protection against overwriting:
100
Sent: Wednesday, July 20, 2005 12:12 PM
Subject: RE: [U2] DATABASE write problem
It can actually be done without the loop. Simply increment a unique
sequential number for every record written so that the key has at
least a time and the sequential number. If multiple records come
through in the same
POSTED FOR NON-MEMBER Anmol Chandrakant Khopade
[EMAIL PROTECTED]
Hi,
I am facing a problem wherein a WRITE operation to a type 19 file is failing
in some cases.
The call to STATUS() function within the ON ERROR clause returns error 40019.
Strangely this problem does not occur for all the
Hi,
I am facing a problem wherein a WRITE operation to a type 19 file is failing
in some cases.
The call to STATUS() function within the ON ERROR clause returns error 40019.
Strangely this problem does not occur for all the writes operations, but
approximately 100 times (out of 60K write
, Inc.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Moderator
Sent: Tuesday, July 19, 2005 4:26 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] DATABASE write problem
POSTED FOR NON-MEMBER Anmol Chandrakant Khopade
[EMAIL PROTECTED]
Hi,
I am facing
conflicts like this.
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anmol
Chandrakant Khopade
Sent: Tuesday, July 19, 2005 5:01 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] DATABASE write problem