Request Types - 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

There are two types of Teradata SQL requests:

  • A single-statement request is a single Teradata SQL statement sent as a request.
  • A multi-statement request is two or more statements that are sent as a request.

Semicolon placement in relation to the rest of a line (for example, at the beginning or end) determines whether a statement is processed as a single-statement request or a multi-statement request.

Request Type Semicolon Placement
Single-statement request Place the semicolon at the end of the statement as the last nonspace character of the line.
Multi-statement request Place the semicolon at the beginning of the line that begins the second through the final statement, and at the end of the final statement as the last nonspace character of the line.