Macro Example |Command Execution Messages | Basic Teradata Query - Command Execution Messages - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-06-12
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

The sample macro produces the following command execution messages in the SYSPRINT file:

.LOGON e/fml,
*** Logon successfully completed.
*** Total elapsed time was 3 seconds.

.EXPORT REPORT FILE=report.out
*** To reset export, type .EXPORT RESET

.SET RTITLE 'Department Information'
.SET FORMAT ON
EXECUTE deptdisplay;
*** Echo accepted.
*** Total elapsed time was 3 seconds.
*** Query completed. 5 rows found. 4 columns returned.

.SET FORMAT OFF
.EXPORT RESET
*** Output returned to console.

.LOGOFF
*** You are now logged off from the DBC.
.EXIT