The WHERE function allows you to specify filter criteria for source data records, similar to the way the SQL WHERE clause works. The WHERE function must contain at least one (1) Boolean function or function set. If the result of the function(s) within the WHERE clause are true (1), the functions that appear below the WHERE function are executed. Otherwise, the functions below the WHERE function are not executed.
Category
Boolean
Syntax
WHERE(boolean_condition)
Parameter and Description
| Parameter | Description |
|---|---|
| boolean_condition | This parameter specifies one (1) or more Boolean functions that return either a true (1) or false (0) condition. |
Example
Map three (3) fields from source datastore CDCIN to target datastore TGT_DS_1. Check the value of source field SRC_FLD4. If the value is a Y, map the three (3) source fields to target datastore TGT_DS_2. Otherwise, do not map any data to target datastore TGT_DS_2.
TGT_DS_1.TGT_FLD1 = CDCIN.SRC_FLD1
TGT_DS_1.TGT_FLD2 = CDCIN.SRC_FLD2
TGT_DS_1.TGT_FLD3 = CDCIN.SRC_FLD3
WHERE (CDCIN.SRC_FLD4 = 'Y')
{
TGT_DS_2.TGT_FLD1 = CDCIN.SRC_FLD1
TGT_DS_2.TGT_FLD2 = CDCIN.SRC_FLD2
TGT_DS_2.TGT_FLD3 = CDCIN.SRC_FLD3
}