Request Types

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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.