BTEQ Sessions - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Using a BTEQ session is an effective way to access a Teradata Database. A BTEQ session includes the following functionality:

  • Establish one or more Teradata Database sessions to submit single- and multi-statement SQL requests using either 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 based columnar reports.
  • Specify operating system commands.
  • Create database objects, such as user-defined functions and stored procedures, that require transfer of source files.