How to Create a Macro | Basic Teradata Query - Creating a Macro - Basic Teradata Query

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

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