PI05285: CAST_DIVISION_FLOAT RETRIEVES UNEXPECTED RESULTS AGAINST SYBASE IQ 15.4

APAR status

• Closed as fixed if next.

Error description

• When calculating division for "bigint" type on Sybase IQ. Query
  calculation shows wrong value due to "cast as float". Layout
  calculation retrieves correct value cause it generates the sql
  with "cast as double".??Since Sybase IQ set width of float to  4
  byte,?bigint type should be converted to double (8byte).??Issue
  can be resolved if I force UDA to always generate "cast as
  double" instead of "cast as float".?(Changed codmod_iq.ini) ??Is
  it an intended behavior or a defect ??Can user use this as a
  workaround ?
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 2                                                       *
  ****************************************************************
  

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

• RA22 PSN

     UP