Managing isql Temporary Files

Go Up to Interactive Query

isql creates temporary files used during a session to store information such as the command history, output file names, and so on. These files are named in the form isql_aa.xx. The files are stored in the directory specified by the TMP environment variable, or if that is not defined, the working directory, or if that is not defined, they are stored in the Windows directory.

To avoid cluttering the Windows directory with InterBase temporary files, specify a different directory for them by defining the TMP environment variable.

When you exit, isql deletes these temporary files. If isql terminates abnormally, then these files remain and may be freely deleted without any adverse effects. You should not delete any of these temporary files while isql is running, because they may be used in the current session.