An operand can be a numeric expression (numeric field, date field, arithmetic expression, numeric literal, numeric function), an alphanumeric expression (alphanumeric field, alphanumeric function, alphanumeric literal, or an alpha group), or a non‑alpha group.
When two alphanumeric items (including variable length items) are compared, if they differ in length, the shorter item is padded with spaces on the right.
You can compare an alphanumeric expression to a numeric expression; however, a warning is issued. A $NUMBER function is automatically applied to the alphanumeric expression and a numeric comparison is done. If the alphanumeric expression does not contain a valid numeric value, a runtime error occurs.
You can also use non‑alpha groups (except restricted non‑alpha groups) as operands in simple relations in conditional expressions. The non‑alpha group is treated as an alphanumeric field whose length is the size of the group. Subordinate fields are not converted; the hexadecimal contents are compared.
You can only use the relational operators CONTAINS and NOT CONTAINS in FOR constructs for CA Datacom/DB native access dataviews.
You can only use LIKE, IN, BETWEEN, and NOT LIKE, NOT IN, and NOT BETWEEN in where conditions in FOR constructs for SQL dataviews.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|