Application Delivery Management
Application Modernization & Connectivity
CyberRes
IT Operations Management
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.
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.