Re: DBTEMP

In article <69lfgv$ko4@cssun.mathcs.emory.edu>, Bill Weaver <billw@fscorp.com> writes >I'm running Online Dynamic Server version 7.22. I have a system that I inherited >and in the environment, the DBTEMP variable is set to a particular file system. >This environment variable is not listed in the System Admin manuals so it would >seem that 7.22 doesn't utilize it. You can find reference to it in the SQL >Reference manual however and it states there that it only is applicable to SE >which I am not running. HOWEVER, I am getting some temporary files in the file >system named by DBTEMP (PSORT_DBTEMP doesn't reference it nor does any other >environment variable)! If this variable "isn't used" by Online, then why are >they appearing and what are they (they all begin with prefixes "en" and "f1"? >Is >it safe to unset this variable and not use it at all? If so, will it use the >temporary spaces I already have defined? In addition to Online, we also utilize >version 6.04 of SQL and I4GL. Could one of these be using it? Dear Bill We are currently running OnLine 5.01.UD4. We have this environment variable set (so it is not SE exclusive). It is used by Ace/4GL programs as a temporary repository for sort work files. Hope this is of benefit. At this stage I am unsure as to its use beyond version 5, but hope to find out soon when we upgrade to OnLine 7. Regards Glyn Balmer glynb@bicceri.demon.co.uk