Calculators

In the Data Management Console, you can now use a variable in a Data Flow with a WHERE filter that contains an IN clause. For example, you could create a WHERE filter such as:

PLANT IN (&PLIST)

When you run the flow, you could use the following values:

'BOS','ATL'

These values would be used to return rows with either value.

Under certain conditions, when working in the DMC Synonym Editor or a Data Flow calculator, the format of a new field is recalculated based on the expression. A new balloon tip has been added, which informs users that the format has been recalculated.

The simplified function DTRUNC, which returns the first day of a time period (YEAR, MONTH, QUARTER), has been extended to return the first day of a WEEK and the last day of any time period.

A new, simplified REPLACE function has been introduced. This function has the following syntax:

REPLACE ( string , pattern , replacement )

The function will replace or remove a substring within a string. The input parameters can have CHAR, VARCHAR, or TEXT as data types. The result is always VARCHAR, with a length that is determined from the input parameters.

A Regular Expression can now be used in WHERE conditions in a SQL SELECT statement. A Regular Expression, or regexp, is a special sequence of characters that describe a search string. The syntax is:

string [NOT] RLIKE regexp