You can monitor the data set resulting from the SELECT statement, and number of rows affected by the UPDATE, INSERT and DELETE statements. If you use sub- or assignment areas, you can see the preview for every level of filter definition.Įxecute SQL Statement: The action allows you to preview the execution of the defined SQL statement.
The rules in the selected filter are applied to the selected input data file. Use Data Filter: The action provides live preview of the parsed data.