MACROCHAR
Valid For
Extract and Replicat
Description
Use the MACROCHAR
parameter to change the macro character of a macro definition to something other than the # character. You might need to change the macro character when, for example, table names include the # character.
The MACROCHAR
parameter can only be used once in the parameter file. Place the MACROCHAR
parameter before the first MACRO
parameter in the parameter file. Anything in the parameter file that begins with the specified macro character is assumed to be either a macro or a macro parameter. All macro definitions in the parameter file must use the specified character.
MACROCHAR
cannot be used with query parameters.
See also "MACRO".
See the Using Macros for more information about using macros.
Default
#
(pound symbol)
Syntax
MACROCHAR character
Example
In the following example, $
is defined as the macro character.
MACROCHAR $ MACRO $mymac PARAMS ($p1) BEGIN col = $p1 END;