This article describes what to do if you get a syntax error when executing a query containing a CASE expression.
Executing a query containing a CASE expression with AcuXDBC Version 8.0.0 results in a syntax error. Does AcuXDBC support CASE?
AcuXDBC Version 8.1 added support for CASE. For versions prior to 8.1, you may use DECODE to obtain the same results. For example, the following two queries are equivalent:
when 'Cat' then 'MEOW'
when 'Dog' then 'WOOF'
when 'Bird' then 'TWEET'
With Version 8.1.0, executing either query against the sample database (created by demo.bat) will return:
The DECODE query will give this result in any version.