Connect CDC SQData

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_functionn]

 

Parameter Descriptions

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

}