16.20 - Null Statements - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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;