Using Teradata SQL in BTEQ - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Using Teradata SQL in BTEQ

All database requests are expressed in Teradata Structured Query Language (Teradata SQL). A Teradata SQL request contains one or more Teradata SQL statements. These statements enable users to perform actions against the Teradata Database such as:

  • Define data - create and modify data structures.
  • Select data - query a database.
  • Manipulate data - insert, delete, and update data.
  • Create Teradata SQL macros - store and execute sequences of Teradata SQL statements as a single operation.
  • Control data - define databases and users, establish privileges, and secure data.
  • BTEQ does not support embedded control characters within quoted strings for SQL requests. Examples of unsupported control characters include a null, carriage return, or line-feed character.