HELP BTEQ - Basic Teradata Query

Purpose  

Returns a list of all available BTEQ commands and non-graphic representations of their syntax. (The SQL Online Help feature includes similar help for SQL commands.)

Syntax  

Usage Notes  

The HELP BTEQ command provides accurate spelling and syntax for all BTEQ commands. The HELP BTEQ command is not suppressed by the QUIET command.

The HELP BTEQ display uses the following characters to represent the command syntax in a non-graphic format:

Brackets, [ ] indicate optional choices that can be omitted.

Braces, { } indicate required choices, one of which must be stated.

A vertical bar | separates different values for options.

Uppercase characters represent reserved words that must be specified exactly as shown.

Lowercase characters represent required, user-supplied values.

The HELP BTEQ command is valid in a Teradata SQL macro.

Example  

To request help, type:

   .HELP BTEQ 

BTEQ Response

BTEQ is a general-purpose utility which enables the user to submit Teradata SQL queries to the Teradata Database; it formats the results and returns them to the screen, file, or printer.

This statement is then followed by an alphabetical listing of the BTEQ commands.

Example 2

The HELP BTEQ command in a Teradata SQL macro appears as:

   ECHO '.HELP BTEQ';