6. QUEL and EQUEL Statements : Save Statement--Save Table Until Date : Description
 
Share this page                  
Description
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).