Dynamic data import / export


simply more productive
Up to 100,000 records can be processed with the freeware version!
  • Home
  • News
  • Executing user-defined SQL statements

Executing user-defined SQL statements

Release notes for version 2.2.1 on October 24, 2011


New SQL Heater

User-defined SQL statements can be executed with the help of the SQL Heater. In addition to simple SELECT statements substituting the Database Lookup Heater, you can also execute INSERT, UPDATE and DELETE statements. Dynamic SQL statements can be composed using placeholder parameters.

e.g. SELECT id from Product_Table where Product_Name = ‚$PRODUCTNAME$‘


Execution stage of .NET Script Heater selectable

The stage during the run at which the .NET Script Heater is executed can now be specified. The following alternatives are possible.

  • Standard: As previously, the code is run once each row/record, when an output value is requested.
  • Per row/record: The code is run before each row/record processed. This may sound similar to the standard setting, but this runs the code regardless of an output value. In this case an output connection for the Heater is optional.
  • Start: The code is executed before the Definition run starts.
  • Finish: The code is executed after the Definition run finishes.