Operands

Expression operands may be of a defined column type, such as INTEGER, FLOAT, LONG, STRING, DATETIME, DAY, and BOOLEAN. If a number assigned to either an INTEGER or LONG variable overflows or underflows the interval of permitted values for that type (that is, - 2147483648;+2147483647 for INTEGER, and - 9223372036854775808; +9223372036854775807 for LONG), then the number wraps around the interval. For example, the value 2147483649 assigned to an INTEGER variable is interpreted as -2147483647.

Operands are automatically converted to a wider type if needed. This feature is relevant for numeric data types INTEGER, LONG, and FLOAT (widening INTEGER -> LONG -> FLOAT) and datetime types DAY and DATETIME (DAY -> DATETIME). In case of comparisons, and set and conditional operations, all operands are converted to the most general type before the operation is performed.

An operand is any expression with a type corresponding to a valid type of a given operation. Operands can be divided into four categories:


iWay Software