Tips for Using BTEQ | Formatting BTEQ Output| Teradata Vantage - 2.2 - Tips for Using BTEQ - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Teradata Vantage
Release Number
Release Date
January 2021
Content Type
Publication ID
English (United States)
To make sure you can see all the columns in request results, run these commands in BTEQ before you run SQL requests:
.sidetitles on
.foldline on ALL
You can call BTEQ from a script or run it from the command line. Follow these tips to copy and paste SQL statements at the command line:
  • To run a single-statement SQL request, press Enter at the end of the line.
  • To run a multistatement SQL request, press Enter after the last line. If you do not press Enter, every statement runs automatically except the statement on the last line.

For details on using BTEQ from a script, see Teradata Vantageā„¢ - Database Administration, B035-1093.