From: Helen Warburton <helen.warburton@rbch-tr.swest.nhs.uk>
>
>Hello I wonder if you can help me:
>
>Error number -243 could not position within a table table-name.
>
>It says that the database server is unable to set the file position
to
>paticular row within the file representing a table.
>
>How do I locate the ISAM error code? The solution is to run bcheck
or
>secheck.
>
>This may seem simple to most of you, but this is a new area for me,
so I
>would appreciate any help that you can offer based in the knowledge
that
>my insight into Informix is limited!
Generally, the application would handle the ISAM error number. If your
application is crashing, it might give you the error number along with
the -243. If you aren't getting any other numbers, then it would seem
that your application is trapping the ISAM error and not giving it
back to you. There *might* be some sort of error log with something
useful in it.
Try the bcheck/secheck utility to repair possible index corruption, if
that doesn't work, investigate permissions and disk capacity.
HTH.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com