Re: Location of temp tables

In IDS 7.3, Temp tables will use the DBSPACETEMP in the following way: Create Temp Table with no log --> Temporary DBSpace from DBSPACETEMP Create Temp Table --> normal DBSpace from DBSPACETEMP (or dbspace of current database, if a normal dbspace is not specified) Select...into temp with no log ---> Round Robin over dbspaces in DBSPACETEMP. Select...into temp --> normal DBSpace from DBSPACETEMP (or dbspace of current database, if a normal dbspace is not specified) Sorts will use the Temporary dbspaces in DBSPACETEMP. If not set, then will use rootdbs. Hope I got that all correct! :-) Michael Hoffman In <a3525a11.0402050219.5720fbd2@posting.google.com> article, Andy Kent mentioned that: : 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.