DQL Statements › WITH Clauses › WITH Clause Operand1

WITH Clause Operand1

►►─┬────────┬─ operand1 ─ comparison-operator ─ operand2 ─────────────────────►◄
   └─ WITH ─┘

Explanation

Operand1 in the WITH clause diagram represents any valid column or key contained in the specified table or an arithmetic expression enclosed in parentheses.

CA Dataquery evaluates the specified name as a column first, then as a key if no column with that name is found. CA Dataquery compares the column, key or arithmetic expression to the value of operand2. See Evaluation of Arithmetic Expressions for more information about how CA Dataquery processes these expressions. In comparing columns, CA Dataquery compares data types. In comparing keys, CA Dataquery only performs logical compares.