Operand1 can be any valid column or key, including a character column, a numeric column, a key, or a repeating field.
Key Name:
If either operand1 or operand2 is a key and the other is a column, the key can contain only one column, but it must be a character column.
Repeating Fields:
A column can be one occurrence within a repeating field. If that is the case, use subscripts to identify which occurrence is to be used. A typical subscript looks like this:
SALES-RESULTS (5,2)
See the CA Dataquery User Guide for detailed instructions.
Table Names:
When operand1 and operand2 represent values in two different tables, prefix one or both with table names and use a period between the table name and column name. Do not use a table name if operand1 is an arithmetic expression.
Numeric Column:
If operand1 of a WITH clause is a single numeric column, its comparison with operand2 is based on the decimal precision of operand1.
|
Copyright © 2014 CA.
All rights reserved.
|
|