A macro consists of one or more statements that can be run 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 (Macro Form) statement.
A macro can include an EXECUTE statement that runs another macro.
Performing a macro is similar to performing a multiple-statement request.