When using the version 8.x AcuSQL precompiler a syntax error is generated that did not occur in earlier versions when the embedded SQL code uses the "COALESCE" function.
An example of this code:
where c_number = :c-number
1) Use a version of the AcuSQL precompiler earlier than 8.x and then compile the intermediate file with the 8.x compiler.
2) Replace the COALESCE syntax with comparable syntax using the CASE statement.
This behavior is corrected by ECN-SQL118 in version 9.0. Install version 9.0 when it becomes available.