Creating an Output Log File - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Creating an Output Log File

To create a new output file named log.out, enter:

   BTEQ  < sampfile >log.out

The file log.out contains:

   .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