Overview | Basic Teradata Query - Overview of BTEQ - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Basic Teradata Query (BTEQ) (pronounced “bee-teek”) is a general-purpose, multi-platform commandline client utility that enables ad hoc and batch submission of Structured Query Language (SQL) requests to one or more instances of Advanced SQL Engine. It is typically used for report generation and lower-volume data load/unload. BTEQ formats the query results and returns them to the screen or to one or more files.

BTEQ results are based solely on Teradata SQL semantics in combination with BTEQ commands that allow returned row data format specification. Direct submission of SQL to other vendors' databases is not supported. The acronym "SQL" is used numerous times throughout this manual. These instances may or may not be qualified with the word "Teradata". It should be assumed the reference is always to Teradata's SQL.

The word "database" is used numerous times throughout this manual. Unless the context is actually about database type object use, it should be assumed the reference is to an Advanced SQL Engine instance or interaction with Vantage solely through an SQL engine instance. In particular, "database" references are employed for brevity to describe usage scenarios based on Call-Level Interface (CLI) client/server protocols that support logging on sessions for sending SQL requests, fetching responses for presenting tabular result rows and generating exported records.