PH06924: DATA TYPES IN THE "CASE WHEN" EXPRESSION ARE INCOMPATIBLE

APAR status

• Closed as suggestion for future release.

Error description

• A relational report with case when statement returns validation
  warning XQE-PLN-0205 The data types in the "case when"
  expression are incompatible. even though the datatypes are both
  characters. This happens when a user-defined function is part of
  the case-when statement.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• This is not a defect in the IBM Cognos Analytics software. The
  Dynamic Query Mode allows expressions to reference in-database
  functions whose signature (input and output types) is unknown to
  Cognos Analytics.
  As a query is validated and planned, query engine takes into
  account data type information. This may result in the query
  engine issuing warnings because the data type is unknown.
  
  If the function were enclosed in another function which is known
  by Dynamic Query such as CAST, then Dynamic Query would use the
  datatype information returned by that function.
  For example CAST( myUDF ( ... ) , integer ).
  
  Importing a function into a Framework Manager model is not
  mandatory before a function can be referenced in an expression.
  By importing a function, metadata about the function
  is made available to the query engine with respect to the data
  type returned by the function and the data types it accepts as
  input.
  
  A known issue exists with the IBM JCC (JDBC) driver and Db2
  whereby it may not return the expected response from JDBC
  DatabaseMetadata.getFunctionColumns method.
  Consequentially, the return type of the function is unknown to
  the query engine from the model. This discrepancy with the data
  type is what is causing the warning.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels