Problem:

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:

           exec sql

               select

                 coalesce(c_info,'')

                 into :the-c-info

                 from customer

                where c_number = :c-number

           end-exec.

Resolution:

Workaround:

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.

Fix:

This behavior is corrected by ECN-SQL118 in version 9.0. Install version 9.0 when it becomes available.