Re: Temp Tables

Posted in 1992

David Kosenko — 27 Aug 92 16:43:47 GMT — source: Informix-list mailing list archive (1991-1998)

Naomi Walker writes: > >I thought you could control where temp tables were created (from 4.1 >Online) using DBTEMP. We sometimes have to create them in Unix file >space. DBTEMP has no effect on temporary *tables* created in OnLine; they will always exist in the root dbspace. Temporary *files*, created by the sort package, will be created in Unix file space. They will be located in: $PSORT_DBTEMP, $DBTEMP, or /tmp (in that order of preference). A future release of OnLine will allow you to specify the dbspace to be used for temporary tables. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** The heart and the mind on a parallel course, never the two shall meet. -E. Saliers