PH13677: LIMITED FUNCTION SET RETURNS WARNING FOR TRUNC

APAR status

• Closed as fixed if next.

Error description

• A DQM package with function set limited to DB2, is returning a
  warning, when the trunc function is used with different
  datatypes.
  Example:
  XQE-PLN-0264 The argument at position 2 of the function 'trunc'
  is invalid in data item 'trunc' of query 'Query1', expected one
  of the following types: 'numeric'.
  Example: trunc([Sales (query)].[Time].[Date];'YYYY')
  DB2 is allowing the same function.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.4                       *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

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