Command Set - 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

Command Set

The BTEQ command set can be categorized as:

  • Session control commands
  • File control commands
  • Sequence control commands
  • Format control commands
  • Use BTEQ commands to perform data control functions. They do not act directly on data.

    BTEQ commands can be categorized into four functional groups, as described in the following table:

     

    BTEQ Command

    Function

    Session control

    Begins and ends BTEQ sessions, and controls session characteristics.

    File control

    Specifies input and output formats and identifies information sources and destinations.

    Sequence control

    Controls the sequence in which other BTEQ commands and Teradata SQL statements are executed within scripts.

    Format control

    Controls the format of screen and printer output.