The SUBSET statement specifies the selection criteria and ordering statement
to be
used by SYSTEM 2000 when creating a
view descriptor. These statements are optional, but omitting them causes the
view to retrieve all the data in the
database. For more details about the default
where-clause, see the discussion about WHERE clauses in
Advanced Topics for Users. Here is an example of a WHERE clause:
subset "where amount<1010";
Multiple selection criteria
can be included in one SUBSET statement. The quoted strings are concatenated
and passed to SYSTEM 2000 for processing:
subset "where amount<1010"
"ob amount";To clear the selection
criteria, submit the following statement:
subset;
For more information about SYSTEM 2000 where-clause and ORDER BY
syntax, see the
SYSTEM
2000 Software: QUEST Language and System-Wide Commands, Version 12,
First Edition manual.