RE: select * from tab into temp with no log

finderr tells you the answer. You have a problem creating temp tables. -229 Could not open or create a temporary file. The database server cannot create a temporary disk file. The file should be created in the directory specified by the DBTEMP environment variable (or /tmp by default on UNIX systems). Check the accompanying ISAM error code, and look for operating-system error messages thatmight give more information. Possibly your account does not have write permission in that directory, or possibly the disk is full. Since Version 5.01, the INFORMIX-SE database server uses the DBTEMP environment variable, but INFORMIX-OnLine Dynamic Server does not. Check onstat -d, DBSPACETEMP etc. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of CSC Employee > Sent: Wednesday, 14 May 2003 5:16 a.m. > To: informix-list@iiug.org > Subject: select * from tab into temp with no log > > > > Helps please, > When I select join from tables tinto temp with no log, I ran > into error > 229. I don't seem to have any problem if select from a single table, > even if with complicate criteria. > > There are plenty of space in temp dbspaces, and log dbscpces. > > Any suggestion what the problem might be? > > Thanks, > chariya > >