This book provides reference information about BTEQ (Basic Teradata Query), a general-purpose, command-based report and load utility tool. BTEQ provides the ability to submit SQL queries to a Teradata Database in interactive and batch user modes, then produce formatted results. BTEQ runs on the client portion of a channel-attached or a network-attached system.
With BTEQ, you can:
Establish one or more Teradata Database sessions to submit single- and multi-statement SQL requests using Teradata Mode or ANSI standard transaction semantics.
Use Teradata SQL statements to view, add, modify, and delete data.
Use formatting commands to produce field-mode columnar reports.
Specify operating system commands.
Create database objects, such as user-defined functions and stored procedures, that require transfer of source files.