Connect CDC SQData

The IF / ELSE functions are two (2) functions that work together to perform conditional processing based on one (1) or more values being evaluated. The IF function tests for a true (1) condition. The ELSE function tests for a false (0) condition.  Connect CDC SQData functions can be performed when a condition(s) meets the criteria for an IF and/or ELSE function.

Note: The IF function can be used without the ELSE function, but the ELSE function cannot be used without the IF.

Category

Specialized

Syntax

IF condition, { true_action [, true_action] } ELSE { false_action [, false_action] }

 

Parameter Descriptions

condition  -  One (1) or more conditions to be tested by the IF function. A condition can be any  Connect CDC SQData function that returns a true (1) or false (0) value.

true_action  -  This parameter specifies one (1) or more actions to be taken if the condition(s) evaluated is true (1). A true_action is usually another Function or nested Function.

false_action  -  One (1) or more actions to be taken if the condition(s) evaluated is false (0). A false_action is usually another Function or nested Function. Notes "? It is important to use  Connect CDC SQData Boolean functions that return a true (1) or false (0) value as the condition within an IF function. Otherwise, the result will always be false." "? It is recommended that you keep each keyword, condition and action on separate lines in the  Connect CDC SQData command script to improve readability."

Example

Terminate the  Connect CDC SQData execution with a Return Code (RC=8) if a CDC record is read that indicates a source record was Deleted.

IF  CDCOP(CDCIN) = 'D'

{

   OUTMSG(8,'A Delete has been detected and is not permitted')

}