The following table lists the basic SQL statements that you can use with macros.
Use this statement… |
To… |
CREATE MACRO |
incorporate a frequently used SQL statement or series of statements into a macro. |
EXECUTE |
run a macro. Note: A macro can also contain an EXECUTE statement that executes another macro. |
DROP MACRO |
delete a macro. |