Problem:

The File Handling manual says that mfsort uses a temporary workfile during sort & merge operations.  What is the name of the workfile and where is it located?

Resolution:

SORT uses the following environment variables to determine the location of the sort work files:

Unix:    TMPDIR

Windows:TMP, TEMP

If the environment variable is not set the current working directory is used.

The temporary sort files are prefixed with M$FST and the actual files created will vary depending upon the input data.  

Example file names:

M$FST000.TMP

M$FST000.001

M$FST000.002.

This applies to both Server Express and Net Express.