Null Statements | SQL Fundamentals | Teradata Vantage - 17.10 - Null Statements - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1141-171K
Language
English (United States)

A null statement has no content except for optional pad characters or SQL comments.

Example: Using a Semicolon as a Null Statement

The semicolon in the following request is a null statement.

/* This example shows a comment followed by
   a semicolon used as a null statement */
;  UPDATE Pay_Test SET ...

Example: Using Semicolons as Null Statements and Statement Separators

The first SEMICOLON in the following request is a null statement. The second SEMICOLON is taken as statement separator:

/*    This example shows a semicolon used as a null
   statement and as a statement separator */
;  UPDATE Payroll_Test SET Name = 'Wedgewood A'
   WHERE Name = 'Wedgewood A'
;   SELECT ...
-- This example shows the use of an ANSI component
-- used as a null statement and statement separator ;

Example: Using a Semicolon that Precedes the Statement

A SEMICOLON that precedes the first (or only) statement of a request is taken as a null statement.

;DROP TABLE temp_payroll;