Difference between revisions of "PACK"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
|||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Remove records from the active table that are marked for deletion | Remove records from the active table that are marked for deletion | ||
− | |||
==Syntax== | ==Syntax== | ||
PACK [ALL] | PACK [ALL] | ||
− | |||
==See Also== | ==See Also== | ||
[[DELETE]], [[DELETED()]], [[RECALL]], [[REINDEX]], [[SET DELETED]], [[ZAP]] | [[DELETE]], [[DELETED()]], [[RECALL]], [[REINDEX]], [[SET DELETED]], [[ZAP]] | ||
− | |||
==Description== | ==Description== | ||
Line 16: | Line 13: | ||
====ALL==== | ====ALL==== | ||
If the ALL option is specified, the PACK command will start at workarea 1 and PACK every open table in all workareas. | If the ALL option is specified, the PACK command will start at workarea 1 and PACK every open table in all workareas. | ||
− | |||
==Example== | ==Example== | ||
Line 32: | Line 28: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
+ | [[Category:NoSQL]] | ||
[[Category:Table Basics]] | [[Category:Table Basics]] | ||
[[Category:Table Basics Commands]] | [[Category:Table Basics Commands]] | ||
[[Category:Data Commands]] | [[Category:Data Commands]] |
Revision as of 05:07, 1 October 2012
Contents
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