Please enable JavaScript to view this site.

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 Descriptions

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

}