In article <34688AFB.728CB008@mail.dec.com>, Roland Schnabel <c-
schnabel@mail.dec.com> writes
>Hello everybody,
>
>we're trying to send an SQL statement via 4GL (SQLWindows) to Informix
>Online 5.01.
>The SQL statement contains an '... order by .. ' on columns that are not
>(and should not be) indexed. We get the following error message:
>
>Cannot write sorted rows. No such file or directory. #567
>
>The DBTEMP variable is set properly to /tmp, which should have enough of
>free disk space.Also on the client side INFORMIX.INI contains a DBTEMP
>entry (set via SETNET.EXE to /tmp).
>
>The server runs on SCO Unix, the clients on Win95 / WinNT 4.0.
>
>Where are those rows sorted? What kind of temporary directories does
>Informix use, and in which order?
>
>(Temporary DBSpaces are not possible with 5.01, neither DBSPACETEMP.
>PSORT_DBTEMP has no effect)
>
>Thanks in advance!
>
>Roland
>
Check you are not running out of space..
--
David Williams