MACROCHAR
Valid for
Extract, Replicat
Description
Use MACROCHAR
to change the macro character to something other than #. For example, you might want to change the character when table names include the # character. Anything in the parameter file that begins with the specified macro character is assumed to be either a macro or a macro parameter. The MACROCHAR
can only be specified once.
To define a different macro character, precede the first MACRO
statement with the MACROCHAR
parameter in the parameter file.
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;