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

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
2.2
Published
January 2021
Language
English (United States)
Last Update
2021-05-08
dita:mapPath
gta1588198788318.ditamap
dita:ditavalPath
dby1605127568110.ditaval
dita:id
B700-4014
Product Category
Analytical Ecosystem
Software
Teradata Vantage
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.