Syntax
The SAVE statement has the following format:
[EXEC SQL] SAVE [schema.]table_name [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, 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.