2.149 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

character

The character to be used as the macro character. Must precede the first macro statement.

Example

In the following example, $ is defined as the macro character.

MACROCHAR $
MACRO $mymac
PARAMS (#p1)
BEGIN
col = #p1
END;