Creating a Macro - Basic Teradata Query

To create a macro, enter the Teradata SQL CREATE MACRO and ECHO commands in an interactive BTEQ session as follows:

CREATE MACRO macroname AS 
( ECHO  '.BTEQcommand'
  ;Teradata SQLrequest;  
 );