Multi-Statement Processing - Basic Teradata Query - 16.20

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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 a Teradata Database until it encounters a semicolon as the last nonspace character of a line. At that time, BTEQ sends all statements to a Teradata Database 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, refer to SQL Fundamentals (B035-1141).