{ EXECUTE | EXEC } macro_name [ ( macro_arguments ) ] [;]
Syntax Elements
- macro_name
- Name of the macro that is to be executed.
- macro_arguments
{ parameter_name = constant_expression [,...] |
constant_expression [,...]
}
- parameter_name = constant_expression
- Parameter name as defined in the CREATE MACRO request, and supplies the value for that parameter.
- This is referred to as a named parameter list.
- The value can be a constant, or an expression involving constants.
- If a parameter is omitted, any default value defined for that parameter is inserted automatically.
- constant_expression
- Constant or an expression involving constants that specifies a parameter value.
- Values are listed in left-to-right order according to the order in which parameter names were specified in the CREATE MACRO request definition. You can specify nulls by typing successive COMMA characters, for example, (a, , b).
- This is referred to as a positional parameter list.
- If a value is not supplied for a parameter, a comma must be entered to account for the missing parameter.
- Any default value defined for that parameter is inserted automatically.