Hello community,
I have a question regarding the Informix nvl() function which seems to react strangely on a cuic Server Version11.5(1) build 1 (11_5_1_10000_86) when creating a simple query, as example:
select
NVL( MAX(CASE WHEN APPLICATIONNAME='VKS' THEN QUEUETIME ELSE null END ),0 ) AS VKS35_MWZ
FROM CONTACTCALLDETAIL LEFT JOIN CONTACTQUEUEDETAIL
ON CONTACTCALLDETAIL.SESSIONID=CONTACTQUEUEDETAIL.SESSIONID
The query works fine when running on the cuic after pushing the button create fields. the Name of the field is not taking the alias name as defined.
Is that a limitation of the product ?
For this case i just have one field but final query has a lot of nvl functions which make really difficult to identify which one is the correct field to adapt in Terms of Name.
Many great thanks for your help.
Victor Ortiz
