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;