Informix index error

Help! Has anyone come across this error message before when using Informix SQL and everything seems ok. 245: Could not position within a file via an index. 103: Isam error: illegal key descriptor (too many parts or too long) I am trying to access a Tetra Chameleon 2000 table and have been able to do this with every table so far apart from this one called oplistm: My select statement is: select price from oplistm where price_list like 'WH'I have also tried like '%WH' , which works but gives me more data due to similar price_list entries (WH and EWH). schema: create table oplistm price_list char(3) product_code char(20) sequence_number char(2) customer_code char(8) __pad004 char(1) currency_code char(3) __pad005 char(3) description char(20) __pad006 char(4)price float new_price float unit_code char(6) __pad009 char(2) unit_code_group char(1) __pad010 char(1) vat_inclusive_flag char(1) __pad011 char(5) unit_qty_per_price float price_start_date char(8) __pad013 char(2) price_end_date char(8) __pad014 char(6) ; create unique index I_oplistm_0 on oplistm (price_list,product_code,sequence_number,customer_code); create index I_oplistm_1 on oplistm (product_code,sequence_number,customer_code); When Informix creates the table it is called oplistm190 etc. I can use the select on this table and it works. However, when I overwrite this table or link it (using Unix ln) to the live table with data in it, I can no longer use the select. Is this because of the log number added to the end of the table under index which is not present in the original? Regards, Peter Neville