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

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
nnw1608578382132.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
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