Define Macros

Overview

The configuration file install-path/etc/macros.cfg defines macro values for substitution into orchestration jobs, and overrides predefined values. Each line in the file represents a macro value in the form KEY = VALUE, where the KEY is the macro name and VALUE is its value, as shown in the following examples.
On a Windows host:
INPUT_FILE_PATH = C:\files\inputfile.txt
On a UNIX or Linux host:
INPUT_FILE_PATH = /home/dfuser/files/inputfile.txt
The examples above set the macro value INPUT_FILE_PATH to the specified path. This macro is useful when you are porting orchestration jobs from one machine to another, because the paths to an input file in different platforms might not be the same. By using a macro to define the input filename, you do not need to change the path to the file in the orchestration job after you port the job to UNIX. Add the macro in both the Windows and UNIX versions of the macros.cfg file, and set the path appropriately in each.
The etc directory contains the macros.cfg file and a macros subdirectory. The macros subdirectory can contain .cfg files. If one or more .cfg files exist in that subdirectory, then they will be read in alphabetical order before the macros.cfg file is read. The last value read becomes the value that is applied.
If your jobs use system and user-created macros, you must create a combined macro file to be able to use the macros in the SAS Visual Process Orchestration Runtime Server. For more information about macros, see the online Help for DataFlux Data Management Studio.

Update Macros

For each orchestration job run, the assigned DFWFPROC process reads the configured macros at the beginning of execution.
When a macro changes, follow these steps to update the macro on the server without having to restart the server, using one of the following procedures.
  1. In the SAS Visual Process Orchestration Web Client, select the Runtime Server by name.
  2. Right-click on the server name and select Unload idle processes from the drop-down menu.
Unloading idle processes also updates macros for all subsequent instances of the DFWFPROC process.