Was this helpful?
SAVE
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.]tablename [UNTIL month day year];
month
Must be specified as an integer from 1 through 12, or the name of the month, abbreviated or spelled out.
day
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, 2499, 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.
Embedded Usage
Syntax elements cannot be represented with host language variables in an embedded SAVE statement.
Permissions
You must own the table.
Locking
The SAVE statement takes an exclusive lock on the specified table.
Last modified date: 11/28/2023