Request Types in SQL Statements | Basic Teradata Query - 17.00 - Request Types - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

There are two types of SQL requests:

  • A single-statement request is a single 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.