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.
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.
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.