BTEQ Comment Elements - 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

BTEQ Comment Elements

 

Element

Function

Rule

* (asterisk)

Begins a BTEQ comment

It must be the first nonblank character on the line.

Text string

Contains the comment text

Can be as many characters as fills the line, less one for the terminator character.

<cr> (carriage return)

<lf> (line feed)

* asterisk

Terminates a BTEQ comment

The rest of the line, after the ending character, must be blank.

BTEQ Comment Example

BTEQ comments begin with an asterisk (*), contain text, and end with one of three termination characters (see table above), as in the following example:

   * Comment text*

Continuing BTEQ Comments

To continue a comment to the next line, create two consecutive comments, as shown in the following example:

   * This table defines all parameters <cr>
   * in the Department table <cr>
   * which is normally updated on a weekly basis <cr>