File Utility Programming (FUP) Reference Manual

FUP Overview
File Utility Program (FUP) Reference Manual—523323-015
1-14
Qualified File Sets
qualifier
is qualifying criteria that you can specify to include files or objects in a file set. You
can specify qualifiers in any order, but use each qualifier only once per file-set list.
EXCLUDE fileset
excludes the files you specify from a process. This specification is identical to
the NOT option. You can include wild-card characters in this specification.
FROM CATALOG[S] catalog-list
includes SQL objects from catalog-list that match the file-set list.
catalog-list
specifies a volume and subvolume (or a DEFINE name of a file) containing
descriptions of the SQL objects (tables, indexes, views, or SQL programs).
START file-id
specifies a starting position within a file set or file-set list. The process starts on
the first file after the file ID you specify. Although the wild-card option is not
valid for this specification, the file ID does not have to correspond to an existing
file. This option is useful for restarting a process that got interrupted.
Asterisk (*) can be used to represent a complete subvolume name or file ID.
For example:
$volume.subvolume.* or $volume.*.* is the correct usage.
However, $volume.subvolume.AA* is the incorrect usage.
WHERE expression
provides additional qualifying criteria for files or objects. The order of
precedence in evaluating expressions is parentheses ( ), NOT, AND, and OR.
time-value is:
[ date ] time
[ time ] date
time is:
hh:mm[:ss]
date is:
dd mmm yyyy
mmm dd yyyy