Error -243 & -105 on Informix 10...

[smathaiv]

Hi,
I am getting the following error on Informix 10

244: Could not do a physical-order read to fetch next row.
I am just running something like below:
select trandt, count(*) from ... where trandt >= "05/01/2007" group by 1 order by 1

When I checked the log, I realized that these 2 errors occured earlier:
243: Could not position within a table
105: ISAM error: bad isam file format.

could you please help?
Thanks.

 

[PHV]

Seems like a corrupted table.
Did you run the check utility ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886