Global Syntax › FIND / GET Selection Criteria

FIND / GET Selection Criteria

The WHERE clause selection criteria specifies criteria for selecting record occurrences based on field values of a named database record or logical record.

Access mode:This criteria clause is invalid when the access switch is set to IDMS.

This selection criteria is an expansion of the:

• FIND/GET WHERE criteria
• COMPUTE GROUP BY HAVING criteria

Syntax:

►►─┬───────┬─┬─ comparison-expression ──┬─────────────────────────────────────►
   └─ NOT ─┘ └─ dba-designated-keyword ─┘

 ►─┬──────────────────────────────────────────────────────┬───────────────────►◄
   │ ┌──────────────────────────────────────────────────┐ │
   └─▼─┬─ AND ─┬─┬───────┬─┬─ comparison-expression ──┬─┴─┘
       └─ OR ──┘ └─ NOT ─┘ └─ dba-designated-keyword ─┘

Syntax rules:

comparison-expression

Specifies a comparison operation to be performed using the indicated operands and operator.

Note: Complete syntax rules for comparison-expression are presented later in this chapter.

dba-designated-keyword

Specifies a logical record keyword that is predefined by the DBA. Dba-designated-keyword is a keyword that applies to the logical record named in the command. The keyword represents an operation to be performed at the logical record path level and serves only to route the logical record request to the appropriate path; it has no meaning to CA OLQ.

When a SHOW LOGICAL RECORDS command is issued, CA OLQ lists the keywords associated with each logical record defined in the current subschema.

Note: This parameter is used in the WHERE clause only.

AND/OR/NOT

Specifies the logical operators to be used in evaluating the WHERE clause.

Table 2 lists the logical operators and their meanings in the WHERE clause. Logical operators are evaluated from left to right in order of precedence; NOT has the highest precedence, followed by AND, then OR. You can use parentheses to force the order of evaluation.

Table 2: Logical Operators: