SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-37
PURGEDATA Command
PURGEDATA works on audited and unaudited files but—unlike most other operations
on audited files—PURGEDATA cannot be used within a user-defined TMF transaction
and cannot be rolled back.
qualified-fileset-list
specifies the tables, partitions, and files to clear.
When clearing an entire SQL table, PURGEDATA also clears data from all indexes
defined on the table. PURGEDATA does not automatically clear alternate key files
of Enscribe files.
If qualified-fileset-list includes a primary or secondary partition of an
SQL table or the primary partition of an Enscribe file, PURGEDATA clears the
entire file or table associated with the partition, including all other partitions, unless
you specify the PARTONLY option; if you specify PARTONLY, PURGEDATA clears
only the partitions included in qualified-fileset-list.
If qualified-fileset-list includes a secondary partition of an Enscribe file
(but not the primary partition) and you do not specify the PARTONLY option,
PURGEDATA does not clear the secondary partition (or any other partitions of that
file).
If SMF is installed on your node, qualified-fileset-list cannot specify any
object or file on a $*.ZYS*. subvolume.
ALLOWERRORS [ ON | OFF | num ]
specifies what happens if errors occur:
If you omit the ALLOWERRORS clause completely, the default is
ALLOWERRORS OFF. If you specify ALLOWERRORS but do not specify an
option, the default is ALLOWERRORS ON.
[ NO ] LISTALL
specifies whether to list the name of each cleared object.
PURGEDATA qualified-fileset-list
[| [,] ALLOWERRORS [ ON | OFF | num ] |]
[| [,] [ NO ] LISTALL |] ;
[| [,] PARTONLY |]
ON Attempt to clear all specified tables, partitions, and files, regardless how
many errors are encountered.
OFF Stop the operation after a single error.
num Clear all specified tables, partitions, and files until the number of errors
exceeds num.