%TimeNull meta-SQL element
Syntax
%TimeNullDescription
Use this meta-SQL to specify a null value for a time field. Only use this meta-SQL in Insert or Update statements. Do not use this meta-SQL in a Where clause.
Note:
This meta-SQL 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 TIME, CURRENT TIME) |
|
All others |
NULL |
Parameters
None.