The OR (logical OR) function takes the result of two (2) or more other Boolean Connect CDC SQData functions and returns a true (1) if at least one of the boolean functions within the OR function is true. If none of the Boolean functions within the OR function is true (0), a false (0) condition is returned.
Category
Boolean
Syntax
OR(boolean_function)
or
boolean_function1 OR boolean_function2 OR [, boolean_function]
Parameters and Descriptions
| Parameter | Description |
|---|---|
| boolean_functions | One (1) or more Boolean Connect CDC SQData functions that will be used within the OR function to determine if any of the functions are true (1). |
| 1 | 0 | Indicates whether a TRUE (1) or FALSE (0) was returned from the OR function. |
Example
Determine which employees have a yearly salary (YR_WAGE) greater than $100,000 or an hourly wage (HR_WAGE) greater than $50. If either of these cases is true, map set the variable HIGH_PAID to Y. Otherwise, set the variable V_HIGH_PAID to N. Map V_HIGH_PAID to the target field TGT_PAYCLASS.
IF YR_WAGE > '100000' OR HR_WAGE > '50'
{
V_HIGH_PAID = 'Y'
}
ELSE
{
V_HIGH_PAID = 'N'
TGT_PAYCLASS = V_HIGH_PAID
}