Difference between revisions of "PACK"

From Recital Documentation Wiki
Jump to: navigation, search
(Products)
 
Line 39: Line 39:
 
[[Category:Table Basics]]
 
[[Category:Table Basics]]
 
[[Category:Table Basics Commands]]
 
[[Category:Table Basics Commands]]
 +
[[Category:Data Commands]]

Latest revision as of 10:05, 30 November 2009

Purpose

Remove records from the active table that are marked for deletion


Syntax

PACK [ALL]


See Also

DELETE, DELETED(), RECALL, REINDEX, SET DELETED, ZAP


Description

The PACK command removes all the records from the active table that are marked for deletion, and frees the disk space that they occupied. If the active table is indexed, the index is updated as the records are removed from the table. Exclusive use of the table is required for the PACK operation.

ALL

If the ALL option is specified, the PACK command will start at workarea 1 and PACK every open table in all workareas.


Example

use diary
? reccount()
       800
set talk on
delete all for date < date()
100 record(s) deleted.
pack
Pack complete, 700 records copied.
? reccount()
       700


Products

Recital Server, Recital