Use of Semicolons in Multi-Statement Processing | Basic Teradata Query - Multi-Statement Processing - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

In a multi-statement request, the semicolons that begin the line are used only to separate the statements. BTEQ does not submit any of the statements to SQL Engine until it encounters a semicolon as the last nonspace character of a line. At that time, BTEQ sends all statements for processing as one single request.

Do not use an ANSI comment statement in conjunction with a semicolon character to indicate the final statement of a multi-statement request. If the semicolon appears after an ANSI comment, it is treated as part of the comment text string. If it appears before an ANSI comment, it does not qualify as the last nonspace character on the line.

For complete documentation on Teradata SQL, see Teradata Vantage™ - SQL Fundamentals, B035-1141.