How to Include a Macro in a Script | Basic Teradata Query - 17.00 - Including a Macro in a Script - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

Use the editor on the system to include a BTEQ macro in script or input stream file. To execute the deptdisplay macro from a script, for example, enter the SQL EXECUTE statement after the LOGON statement in the script:

.LOGON tdpid/userid, password
EXECUTE deptdisplay;
.LOGOFF