Re: DBTEMP variable and sorted rows

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