Re: Errors -245 and -346, Informix On-Line 4.1, HPUX 7.0

Posted in 1991

Walt Hultgren {rmy} — Wed, 25 Sep 91 14:45:28 -0400 — source: Informix-list mailing list archive (1991-1998)

Path: emory!wupost!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!ucbvax!hplabs!pyramid!infmx!news From: cortesi@informix.com (David Cortesi) Newsgroups: comp.databases.informix Message-ID: <1991Sep25.170807.3677@informix.com> Date: 25 Sep 91 17:08:07 GMT References: <ggordon.685715811@uclagsm> Sender: news@informix.com (Usenet News) Reply-To: cortesi@informix.com Organization: Informix Software, Inc. In article <ggordon.685715811@uclagsm> ggordon@agsm.ucla.edu (Glen Gordon) writes: >... periodically, application programs > which worked flawlessly under 2.11, receive one of two errors from the > On-Line engine: > -245 or -346.> > The text of the error messages is as follows: > > -245 Could not position within a file via an index. > ... Unless the ISAM error code or an operating system message points ^^^^^^^^^^^^^^^^^^^ > to another cause, run the bcheck utility to verify file integrity. > > -346 Could not update a row in the table. > > ...Check the accompanying ISAM error code ^^^^^^^^^^^^^^^ > So: what was the ISAM error code? It's a number between 0 and -199 which is in the SQL Communications area. In esql/c, sqlca.sqlerrd[1]; in 4GL it's sqlca.sqlerrd[2]. The ISAM error codes are spelled out in the same error message book you are quoting from.