SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
Q-3
Qualified Fileset List
OWNER = user-id
restricts operations to files in fileset owned by a Guardian user ID specified:
{ group-name.user-name }
{ group-name.* }
{ group-number,user-number }
{ group-number,* }
For more information about user IDs, see Security on page S-11.
timestamp-restriction
restricts operations to files in fileset that were created, modified, or last opened
before or after a specified date, or that have a NOPURGEUNTIL attribute before or
after (or greater than or less than) a specified date and time. (A later date is
greater than an earlier date; for example, June 3, 1991 is greater than May 13,
1991.)
Specify dates and times:
You can include leading zeros in dd, hh, mm, or ss.
You can include blanks between dd, mmm, and yyyy in ddmmmyyyy. You must
include a blank between dd and yyyy in mmmddyyyy.
The default date is the current date. The default time is 0:00:00.
FILECODE { < | <= | = | >= | > | <> } integer
restricts operations to files in fileset that have a FILECODE less than, less than
or equal to, equal to, greater than or equal to, greater than, or not equal to a
specified integer.
EOF { < | <= | = | >= | > | <> } integer
restricts operations to files in fileset that have an EOF less than, less than or
equal to, equal to, greater than or equal to, greater than, or not equal to a specified
integer. (An EOF is a relative byte address that is an end-of-file pointer. You can
use FILEINFO to display the EOF value of a file.)
mmm JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, or DEC
in uppercase or lowercase
dd an integer from 1 through 31
yyyy a 4-digit integer from 1900 through 2999
hh an integer from 0 through 23
mm a 1 or 2-digit integer from 0 or 00 through 59
ss a 1 or 2-digit integer from 0 or 00 through 59