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.