File (-F or -FILE)

Use the File adapter command (-FILE) for database sources, or in a GET function to write the retrieved data to a temporary file that is read by either the Command Server. This is useful when the amount of data retrieved by the adapter is large, possibly resulting in high memory consumption. By default, that is, without this command, data is passed between the adapter and the database server in memory. The default specification for this adapter command is for the temporary file to be created in the same directory as the map. The temporary file is then deleted after the map completes.


-FILE [directory]
Value
Description
directory
Specify the directory in which the temporary file should be created.

It is recommended that you specify a value for the StreamMaxMemLimit Resource Manager setting in the dtx.ini file to limit the memory consumption of the process you are running, instead of using the File database adapter command (-F or -FILE).

If you are currently running processes that are using the File database adapter command (-F or -FILE) and are retrieving data without resulting in high memory consumption, you can continue to use this command.

Do not use the File database adapter command (-F or -FILE) when you are running maps in burst mode. Instead, use the StreamMaxMemLimit Resource Manager setting in the dtx.ini file to limit memory usage.