Re: Location of temp tables

andykent.bristol@virgin.net (Andy Kent) wrote in message news:<a3525a11.0402050219.5720fbd2@posting.google.com>... > According to the documentation of the SET TEMP TABLE_SPACE statement, > > "When the CREATE TABLE or CREATE Temporary TABLE statement includes no > fragmentation clause, the database server uses the dbspace of the > current > database as the default storage location." > > I thought it used DBSPACETEMP. Does the above comment only apply to > XPS and / or 9.x or have I been making an incorrect assumption? > > Andy Kent > Email: andykentATfreeukDOTcom. Create temp table test_temp(id serial ) ; On my 9.21 database when I create a temp table it uses the current default dbspace for the database. My envs: DBTEMP=/usr/local/db_space/informix_temp PSORT_DBTEMP=/usr/local/db_space/informix_temp Now when I do Create temp table test_temp(id serial ) with no log ; It still puts it in the same spot. I thought in fact that this worked differently. Oh well.