IF-THEN-ELSE optimization has been enhanced.

The default OPTIFTHENELSE setting is set to ON:

ENGINE SQLENG SET OPTIFTHENELSE ON 

This setting optimizes all relational adapter IF-THEN-ELSE FOCUS expressions as CASE or DECODE SQL expressions.

Valid OPTIFTHENELSE settings are:

• ON (default). Generates SQL CASE expressions for FOCUS IF-THEN-ELSE expressions.
• OFF. Suppresses generation of SQL CASE or DECODE expressions for IF-THEN-ELSE and/or DECODE expressions.
• CASE/ON CASE. Equivalent to ON.
• NOCASE/OFF NOCASE. Equivalent to OFF.

Starting in Version 7 Release 7, relational adapters optimize IF-THEN-ELSE DEFINE fields only as SQL CASE statements. The WHERE predicate without CASE is no longer generated.