NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
Q-1
Q
Qualified Fileset List
A qualified fileset list specifies a set of objects and files for an SQLCI utility operation
and optionally includes clauses that restrict the objects and files operated on based on
attributes of the objects and files.
{ fileset-list [ restrictions ] }
{ }
{ ( fileset-list [ restrictions ] }
{ [, fileset-list [ restrictions ] ] ... ) }
fileset-list is:
{ fileset }
{ ( fileset [ , fileset ] ... ) }
restrictions is:
[| FROM CATALOG[S] catalogs |]
[| WHERE expression |]
[| EXCLUDE fileset-list |]
[| START startfile |]
expression is:
{ ( expression ) }
{ NOT expression }
{ expression AND expression }
{ expression OR expression }
{ OWNER = user-id }
{ timestamp-restriction }
{ FILECODE { < | <= | = | >= | > | <> } integer }
{ EOF { < | <= | = | >= | > | <> } integer }
{ file-attribute
timestamp-restriction is:
{ MODTIME } {BEFORE} {ddmmmyyyy [hh:mm:ss] }
{ EXPIRATIONTIME } {AFTER } {mmmdd yyyy [hh:mm:ss]}
{ CREATIONTIME } { < } {hh:mm:ss }
{ LASTOPENTIME } { > }