DQL Statements › WITH Clauses › WITH Clause Operand2

WITH Clause Operand2

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

Explanation

Use one of the following as Operand2 of a WITH clause, depending on its compatibility with operand1 or with a particular operator.

• A Datadictionary name of a column in the last table named
• A Datadictionary name of a key in the last table named
• A literal value
• The word null (meaning empty)

See the following pages for explanations of these operand2 options.

CA Dataquery evaluates the name specified for operand2 as a key first, then as a column if no key is found with that name. If a key or column is named, CA Dataquery compares the contents of the column to operand1. If a literal value or null is specified, that value is compared to operand1. The value of the column, key, or literal must be structured the same as the value for operand1.

Note: Do not use the operator CONTAINING if operand2 is a column or key.