A macro consists of one or more statements that can be executed by performing a single statement. Each time the macro is performed, one or more rows of data can be returned.
A frequently used SQL statement or series of statements can be incorporated into a macro and defined using the SQL CREATE MACRO statement.
The statements in the macro are performed using the EXECUTE statement.
A macro can include an EXECUTE statement that executes another macro.
Performing a macro is similar to performing a multistatement request.
- The SQL CREATE MACRO statement, see “CREATE MACRO” in SQL Data Definition Language - Syntax and Examples, B035-1144.
- The EXECUTE statement, see “EXECUTE (Macro Form)” in SQL Data Manipulation Language , B035-1146 .