Mapping conditional functions: CondFuncMapper element

The CondFuncMapper element has attributes that you use to customize CASE statements. These attributes are listed in Table 11-14.

Table 11-14

Attributes of the CondFuncMapper element

Attribute name	Description	Required?
CaseWhenString	String to use instead of CASE WHEN	No. Default is CASE WHEN.
WhenString	String to use instead of WHEN	No. Default is WHEN.
ThenString	String to use instead of THEN	No. Default is THEN.
ElseString	String to use instead of ELSE	No. Default is ELSE.
EndString	String to use instead of END	No. Default is END.

Example: Mapping the CASE statement

Your database uses a SWITCH statement instead of a CASE statement. SWITCH is not standard SQL. The Actuate SQL CASE prototype is as follows:

CASE [<ValueExpression>]
{<WhenClause>} […n]
[ELSE <ValueExpression>]
END

The mapping for SWITCH is as follows:

<CondFuncMapper CaseWhenString="SWITCH ("

  WhenString=","

  ThenString=","

  ElseString=", TRUE,"

  EndString=")" />

This mapping produces a SWITCH statement such as:

SWITCH (

  Country IN ('Canada', 'Mexico', 'USA'), 'North America',

  Country IN ('Argentina', 'Brazil', 'Venezuela'), 'South
    America',

  Country IS NULL, '(Not Known)',

  TRUE, 'Rest of the world')

Copyright Actuate Corporation 2012