Strange results from DB2 in Quiz

Edis, Bob bob.edis@fleetpride.com
Thu, 3 May 2001 14:01:04 -0500


G'day all

Environment: PH 8.21D4, WinNT 4.0, HitODBC 400, DB/400 

We are using HitODBC to pull data from a DB2 database on an AS/400 machine
and are getting erroneous results in PowerHouse Quiz.  E.g.

Case record:

DB2 shows the cost amount column as 3.670
DecisionStream using the above ODBC driver shows 3.670
Quiz using the above ODBC driver shows 3.610.

In another case Quiz reports 4.950 whereas DB2 and DS show 5.00.

The values reported by DB2 and DecisionStream are the correct ones.  The
column is stored to 3 decimal places (float) in the DB2 table.

The discrepancy between Quiz and DecisionStream is NOT consistent.  I.e.
some records in the table match exactly.

Any ideas why Quiz is reporting incorrect values?  

Regards,

Robert Edis
Manager - Business Intelligence
FleetPride 
520 Lake Cook Rd., Suite 100
Deerfield IL 60015
Tel: 847.572.8039
Fax: 847.444.1096
www.fleetpride.com