Accessing Non-SQL-Defined Databases › Expansion of Extended-search Condition

Expansion of Extended-search Condition

The parameters used in the expansion of Extended-search Condition specify criteria used to select rows from tables.

Syntax

Expansion of extended-search-condition

►►─┬─ search-condition ───┬─┬──────────────────────────────────────┬──────────►◄
   └─ set-specification ──┘ │ ┌──────────────────────────────────┐ │
                            └─▼── AND ──┬─ search-condition ───┬─┴─┘
                                        └─ set-specification ──┘

Parameters

search-condition

Specifies a search condition whose value must be true for the row or rows to be included in the result table.

set-specification

Specifies that only rows participating as owner and member in the named set be included in the result table. For expanded set-specification syntax, see Expansion of Set-specification Statement.

Usage

Evaluation

The full search condition is satisfied when the value of all its operands are true. It is not satisfied when the value of any of its operands is either false or unknown.

Order of Evaluation

CA IDMS effectively evaluates from left to right after first evaluating each operand individually.

You can use parentheses to override the default order of evaluation. Operands in parentheses are evaluated first.