This topic contains sections marked as revised for this release
$db:select.LAB13STA.ARGOSTR.XREF.STATE=$source/AirlineRequest/Purchase/Customer/State
The XPath in this example selects only the records from the database where the value in the STATE column for each record matches the value of the State field from the input message. In the spreadsheet pane the $db:select statement is associated with a For entry which is used to iterate over the mappings for the target message. For each row in the database matching the $db:select statement a separate target message is created with the mappings beneath $target.
The following steps describe how to create message mappings to generate a target message based on records in a database matching the contents of an input message: