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. |