PERFORM_COND_ACTION Function

Function to perform an action on a target entry based on the result of a conditional operation.

Parameters: (String, String, String,String, String);

Returns: NULL;

The actions available are:

    ERROR - the target record will be set to the error state and will not be migrated

    SKIP - the target record will be set to the skipped state and will not be migrated

    WARNING - the warning will be added to the target record, however it will still be migrated

The first parameter is the first value in the conditional operation and can be NULL.

The second parameter is the operation and MUST be one of =, !=, CONTAINS or NOT_CONTAINS.

The third parameter is the second value in the conditional operation and can be NULL.

The fourth parameter is the action to perform if the condition evaluates to TRUE and must be one of ERROR, SKIP or WARNING.

The fifth parameter is the message to be recorded if the action is performed. If NULL, a default will be used.

If the operation is NULL or not recognised, the 'On Error Action' for the assignment mapping will be performed.

If the action is NULL or not recognised, the 'On Error Action' for the assignment mapping will be performed.

If the condition evaluates to TRUE, the action will be perfomed and the value NULL will be returned.

If the condition evaluates to FALSE, no action will perfomed and the value NULL will be returned.

Example:

PERFORM_COND_ACTION([name],'CONTAINS','-E','SKIP','Records where name suffix is -E are skipped')

            Value of [name] is 'Incident-E'

            Result: NULL. The target entry will record an error 'Records where name suffix is -E are skipped'.