Displaying Script Results

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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;