Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
>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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.