|
|
|
Valid in: SQL, ESQL
The Save statement directs the DBMS Server to save the specified table until the given expiration date. By default, base tables have no expiration date. An expiration date cannot be assigned to a system table.
|
|
|
The Save statement has the following format:
[EXEC SQL] SAVE [schema.]table_name [UNTIL month day year];
Must be specified as an integer from 1 through 12, or the name of the month, abbreviated or spelled out.
Must be a valid day of the month (1 to 31), and year must be a fully specified year, for example, 2001. The range of valid dates is January 1, 1970 through December 31, 2035, inclusive.
Note: If the until clause is omitted, the expiration date is set to no expiration date. To purge expired tables from the database, use the verifydb command. Expired tables are not automatically purged.
|
|
|
Syntax elements cannot be represented with host language variables in an embedded Save statement.
|
|
|
You must own the table.
|
|
|
The Save statement takes an exclusive lock on the specified table.
|
|
|
The following example saves the employee table until the end of February 2001:
save employee until feb 27 2001;