INFORMIX WHSE A / 5725D1400 / C10 - IDS 12.10

For an offloaded query you may observe an error like 
 
26561: cannot map to Informix sqlcode:  IWA 
error:-904,'57011',Task 
canceled:QueryExecutionTerminatedPremature 
 
This is reported for a query with a case expression on a 
varchar() column and an inner join on two tables. 
 
When the datatype of the column used in the case expression is 
changed from varchar() to char() the error does not happen. This 
may serve as a temporary circumvention for you.

**************************************************************** 
* USERS AFFECTED:                                              * 
* SQL that has in projection clause a CASE-WHEN-ELSE construct * 
* that happens to emanate NULL for a varchar string type as    * 
* part of the result.                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************

Problem Fixed In IDS-12.10.xC5

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

24.11.2014
16.10.2015
16.10.2015