Re: Help with INFORMIX error message

> > > I'm experiencing a problem with a INFORMIX 4GL program > that I'm hoping someone has seen before and can offer a > solution. > > The error message I'm getting is: > > SQL statement error number -242 > ISAM error number -2> Could not open database table (profile). > -242 Could not open database table table-name. The database server is unable to begin reading a table. Check the accompanying ISAM error code for more information. There may be a problem with file permissions, or a hardware error, or the system catalog may have been corrupted. Unless the ISAM error code or an operating system message points to another cause, run the bcheck utility to verify file integrity . -2 No such file or directory. An operating system error code with the meaning shown was unexpectedly returned to the database server. Look for operating system error messages that may give more information. If you have an SE engine (looks like it) then check the directory where the database lives for the actual files that represent your table. > Does any know the mapping for the error numbers to the actual > error? > They should be in the 4gl reference manual in the appendices. > If it's important, I'm running a very old verison of INFORMIX > version 1.10.04E, created around the 1988 time frame. You may not have finderr - which I just used to find these errors. > > Please respond to this newsgroup as well as to me directly. > Ok. cheers j. _____________________________________________________________________________ Jack Parker |"Almost had a heart attack, Hewlett Packard, BSMC Boise, Idaho, USA| Looking in my rear-view mirror, jparker@hpbs2561.boi.hp.com | Saw myself the next car back, (208) 396-5388 (W) (208) 384-1623 (H) | Looking in my rear-view mirror, | About to have a heart attack." | - JT _____________________________________________________________________________ I must be getting road fever - my third car related quote in a week! _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________