Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Environment Variables » Introduction to SQL Anywhere environment variables

SYBASE environment variable Next Page

TMP, TEMPDIR, and TEMP environment variables


Specifies the location of SQL Anywhere temporary files.

Syntax

TMP=path

TMPDIR=path

TEMP=path

Remarks

SQL Anywhere software may create temporary files for various operations. Temporary files are held in the directory specified by one of the TMP, TMPDIR, or TEMP environment variables. If more than one of these environment variables is specified, then the first of TMP, TMPDIR, and TEMP is used.

SQL Anywhere Server checks the SATMP environment variable first. If it is not specified, then these environment variables are checked. See SATMP environment variable.

If none of the environment variables is defined, temporary files are placed in the current working directory of the server. On Unix only, if none of these environment variables are found, then /tmp is used.

On Windows CE, you can use the registry to specify the directory to use as the server's temporary directory.

For more information about setting the temporary directory value, see Registry settings on Windows CE.

Using shared memory connections with older software

In SQL Anywhere version 9 and earlier, the environment variable ASTMP is equivalent to SATMP. If you are using shared memory to connect version 9 and version 10 software, you must set the SATMP and ASTMP environment variables to specify the location of the temporary file.

See also