Displaying Script Results - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.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;