NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
N-5
Defaults
Defaults
The default is NOPURGEUNTIL 0, which specifies that the object can be purged at any
time.
If you specify a date but omit time, the time 00:00 is used.
If you specify a time with no date, the current date is used.
Examples—NOPURGEUNTIL
•
The following NOPURGEUNTIL values prevent purging until 1997:
NOPURGEUNTIL JAN 01 1997
NOPURGEUNTIL 31 DEC 1996, 23:59
NULL Predicate
NULL is a predicate that determines whether a column contains a null value.
Considerations—NULL
•
If any expression in the NULL predicate evaluates to a value other than null, then
the IS NOT NULL predicate evaluates to TRUE; otherwise, IS NOT NULL
evaluates to FALSE.
b is required space
mmm is a 3-character month value (JAN, FEB, MAR,APR, MAY, JUN, JUL,
AUG, SEP, OCT, NOV, or DEC)
dd is a 2-digit day value (01, 02, ... , 31)
yyyy is a 4-digit year value
hh is a 2-digit hour value (00, 01, ... , 23)
nn is a 2-digit minute value (00, 01, ..., 59)
row-value-specification IS [ NOT ] NULL
row-value-specification is:
{ expression [, expression ] ... }
{ ( expression [, expression ] ... ) }