Strange results from DB2 in Quiz

[Edis, Bob]

G'day all

This is a case of not examining the code closely enough.  The Quiz code was
NOT looking at the same column as the DecisionStream code!  (a very close
alias though)

In my experience most PowreHouse issues stem from either bad data or bad
facts.  This is a case of the latter.

Blue

-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Thursday, May 03, 2001 2:01 PM
To: 'powerh-l@list.swau.edu'
Subject: Strange results from DB2 in Quiz


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


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.