SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
Q-4
Qualified Fileset List
file-attribute
restricts operations to files in fileset that have one of these characteristics or file
attributes:
BROKEN and CRASHOPEN are states described under FILEINFO Command on
page F-9.
FORMAT1 selects files or SQL objects that are in the original disk format.
FORMAT2 selects files or objects that are in the new, larger disk format.
SAFEGUARD selects files with SAFEGUARD ON.
SQL selects files that are SQL tables, views, or indexes.
SQLPROGRAM selects files that are SQL object programs.
Other characteristics and attributes are described in separate entries.
EXCLUDE fileset
specifies a set of files to exclude from the fileset you specified just before the
WHERE clause with the EXCLUDE clause. EXCLUDE is useful for specifying files
from all subvolumes except $SYSTEM.SYSTEM:
$SYSTEM.*.* EXCLUDE $SYSTEM.SYSTEM.*.
START startfile
designates a starting position within the files in fileset.
START is useful when a utility operation is interrupted and you need to start a new
utility operation at the point of the interruption.
SQL utilities process files in the order in which you specify them within
fileset-list. Each fileset within fileset-list is processed before the
next one. Within the set of files specified by a single fileset with wild-card
characters, utilities process files in alphabetic order by fully qualified Guardian
AUDITED INDEX ROLLFORWARDNEEDED
BROKEN KEYSEQUENCED SAFEGUARD
COLLATION LICENSED SECONDARY PARTITION
CORRUPT OPEN SHORTHAND VIEW
CRASHOPEN PARTITION SQLPROGRAM
ENSCRIBE PRIMARY PARTITION SQL
ENTRYSEQUENCED PROGID TABLE
FORMAT1 PROTECTION VIEW UNSTRUCTURED
FORMAT2 RELATIVE VIEW