C-ISAM error -22
I am executing the following sql statement:
select transaction,serial_no
from oldflow
where trans_date >"91.08.31"
into temp t1
and getting the following error after selecting approximately 15 MB of
data:
-246: Could not do an indexed read to get the next row.
C-ISAM -22: unknown error 166052.
At this point the temp table t1 no longer exists as far as isql is concerned.
The *.dat and *.idx files in the /tmp directory still remain.
To what is this C-ISAM error referring? C-ISAM error numbers in my manual
begin at -100.
I am using Informix 2.10.03K on an HP9000/370.
The table oldflow is defined as follows:
Column name Type Nulls
----------------------------------------------
transaction serial no
serial_no char(6) no
serial_type char(1) no
action smallint no
shift char(1) no
station_id smallint no
operator_id smallint no
trans_date date no
trans_time char(8) no
component_id integer yes
and has the following indexes:
Index name Owner Type Cluster Columns
----------------------------------------------------------
oldflw1 zing dupls No serial_no
serial_type
oldflw2 zing dupls No trans_date
Thanks in advance for your help.
--
- eko
__
| |
| | ___________________________________________________________
| \\ | |
| \\ | Ellen K. Osinski |
| | | Hewlett-Packard |
\\ \\ | Boise Site Operations - Boise Surface Mount Center |
/ \\ | 11413 Chinden Blvd |
| ---/\\ | Boise, ID 83714-1023 |
| | | |
| | | phone : (208) 323-4904 |
| * | | e-mail: ellen@hpdmmgv.boi.hp.com |
| | | telnet: 1-323-4904 |
|___________| |___________________________________________________________|