NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
Q-4
Qualified Fileset List
file-attribute
restricts operations to files in fileset that have one of the following
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, as follows:
$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 name. (To
determine the processing order to select the appropriate startfile, issue a
FILENAMES command with the same qualified fileset list used for the utility.)
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