Tips for Using BTEQ - 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.