Re: 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. I believe the problem is you are running out of disk space where Informix is writing the temporary table. I'll bet if you check, /tmp (or where your DBTEMP environment variable points) only has about 15MB of space on it. Try having DBTEMP point someplace with more space and see if that fixes your problem. jeffl ---- Jeffrey F. Lawhorn Information Systems Group Programming Manager Unix, C, and Database Consulting jeffl@isg.com 450 B Street 16th Floor sdsu!isg100!jeffl San Diego, CA 92101 (619) 234-3405 x274