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.
Hello, Hope this hasn't been covered already.
Does anyone know of a problem using UPDATE WHERE CURRENT OF statement?
We are using Informix 4.10 Tools and engine. We declare a SELECT cursor
FOR UPDATE for each row in an input array, after the row, we then do an
UPDATE WHERE CURRENT OF statement. The error we get is -346 Could not update
row in the table. ISAM -126 bad row id (or -105 bad isam file format).
This is happening at multiple sites (sometimes the same rowid number shows
up at different sites). We have tried tbcheck and find no errors.
A retry of the program will work fine even without a tbcheck.
----------------------------------------------------------------------------
**** **T* John Regep
**** **** Store Systems Developement
**** *R** Kmart Corporation
********* 3100 West Big Beaver
***A* **** Troy, MI 48084
**** ****
*M** **** uunet!kmart!jregep
----------------------------------------------------------------------------
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.