Re: Informix index error
In article <01bce850$b35bd920$07fd82c1@informix.dm>, Postbox
<postbox@dial.pipex.com> writes
>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?
>
Sort of!
It means that your create table statement was wrong. The table
structure does not match up with the structure of the C-ISAM file.
Are you sure you can do this? Just because the file is an ISAM file
does not mean it is an "Informix C-ISAM" file and can be linked to
an Informix table. ISAM is not a standard file format!
>Regards,
>
>Peter Neville
>
>
--
David Williams