%DateNull meta-SQL element

Syntax

%DateNull

Description

Use the %DateNull meta-SQL variable to specify a null value for a Date field. Only use this meta-SQL in Insert or Update clauses. Do not use this meta-SQL in a Where clause.

Note:

This meta-SQL variable is not implemented for COBOL.

This meta-SQL resolves into a database-specific SQL substring, as shown in the following table:

Database	Resolved Substring
DB2	NULLIF(CURRENT DATE, CURRENT DATE)
All others	NULL

Parameters

None.