Null
Purpose
Provides a method for including a blank line or self‑contained comment within an SQL request, such as a multistatement request, macro, stored procedure, and so on.
Syntax
where:
|
Syntax element … |
Specifies … |
|
pad_character |
a valid pad character, such as a SPACE character. |
|
SQL_comment |
a valid SQL comment string. |
ANSI Compliance
Although they are closely related to the ANSI SQL concept of separators, null statements are a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
None.
Invocation
Nonexecutable.
Definition: Null Statement
A statement that has no content except for optional pad characters or SQL comments.
Example
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
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
A SEMICOLON that precedes the first or only statement of a request is taken as a null statement.
; DROP TABLE temp_payroll;