Displaying Script Results - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-02-20
dita:mapPath
kil1527114222313.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Depending on the configuration of the system SYSPRINT specification or system output settings, BTEQ either displays the results on the user terminal or writes them to the specified file:

.Logon e/fml, password, acctid 
*** Logon successfully completed.
*** Total elapsed time was 3 seconds.
.SET SEPARATOR ' | '
SELECT * FROM department; 
*** Query completed. 5 rows found. 4 columns returned.
*** Total elapsed time was 3 seconds.
  DeptNo | DeptName      | Loc |  MgrNo
  ------   --------------  ---    -----
     500 | Engineering   | ATL |  10012
     700 | Marketing     | NYC |  10021
     300 | Exec Office   | NYC |  10018
     600 | Manufacturing | CHI |  10007
     100 | Administration| NYC |  10011
.LOGOFF  
*** You are now logged off from the DBC.
.EXIT;