SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

N-5

NOPURGEUNTIL File Attribute

NOPURGEUNTIL is a Guardian file attribute that specifies an expiration date and time

after which a table or index can be purged or dropped. NOPURGEUNTIL applies to

key-sequenced, relative, and entry-sequenced tables and to indexes.

SQL stores the date and time in local civil time (LCT).

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.

Example—NOPURGEUNTIL

These NOPURGEUNTIL values prevent purging until 2003:

NOPURGEUNTIL JAN 01 2003

NOPURGEUNTIL 31 DEC 2003, 23:59

{ mmmbddbyyyy [, hh:nn ] }

NOPURGEUNTIL { ddbmmmbyyyy [, hh:nn ] }

{ hh:nn }

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)