QUEL Reference Guide > QUEL Reference Guide > QUEL and EQUEL Statements > SAVE--Save Table Until Date
Was this helpful?
SAVE--Save Table Until Date
Valid in: QUEL, EQUEL
Saves a base table until a specified date.
This statement has the following format:
[##] save tablename until month day year
The save statement enables you to specify a table's expiration date. The verifydb command destroys expired tables. (Tables are not destroyed automatically upon expiration.) Only the owner of a table can save that table. By default, tables have no expiration date when created. To clear an expiration date, omit the until clause. For example, save mytable clears any expiration date from "mytable".
Month must be an integer from 1 through 12 or the name of the month, abbreviated or spelled out. Day must be the day of the month (1-31), and year must be fully specified (for example, 1999 or 2003).
Last modified date: 01/30/2023