News
Calculations on date and time fields
Release notes for version 2.2.5 on January 30, 2012
New AddDays Heater
Using the AddDays Heater values can be added to date and time fields, or when negative, subtracted from them. Calculating with days, as suggested by the name of the Heater (function) is not all. By amending the default option in the configuration popup, you can also offset dates by years or months and times by hours, minutes or seconds.
TextFile Adapter with optimized preview
Release notes for version 2.2.4 on January 16, 2012
TextFile Adapter with optimized preview function
A preview in the TextFile Adapter in the export mode on the WRITE side is only shown when this is explicitly confirmed as wanted (click in the preview area). This significantly speeds up the processing of large CSV database export Definitions. It prevents extra accesses to records on the READ side being needed, because these could result in additional maintenance of the database server.
New Stop Heater/Function
Release notes for version 2.2.3 on January 02, 2012
Stop Heater for controlled termination of Definition execution
By making use of the new Stop Heater you can prematurely terminate an import/export run.
Two kinds of termination are possible:
- normal termination after processing of a specified number of rows
- immediate termination with a specified error message
IF-THEN-ELSE Heater additional checks
Release notes for version 2.2.2 on November 28, 2011
IF-THEN-ELSE Heater has additional checks
You can now check whether one of the following conditions applies to the incoming value when using the IF-THEN-ELSE Heater.
- IsNull – checks whether the value is NULL or DBNULL
- IsEmpty – checks whether the value is empty or has no content
- IsNumber – checks whether the value is numeric
- IsDateTime – checks whether the value contains a date and/or time
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$‘
