No "cents" when getting data from DB2
Posted: Tue Jan 11, 2011 9:17 pm
I am using Base to fetch information from DB2 tables via ODBC, located remotely on our company's mainframe.
I notice however that fields that have been defined as DECIMAL(15,2) all are returned with the cents rounded down. In other words: an amount of 123.57 is returned as 123.00
How can I get the pennies back? CASTing and CONVERTing does not do the trick.
Another application I use the same ODBC driver with has no problems with it. It is just OOo that has this.
I notice however that fields that have been defined as DECIMAL(15,2) all are returned with the cents rounded down. In other words: an amount of 123.57 is returned as 123.00
How can I get the pennies back? CASTing and CONVERTing does not do the trick.
Another application I use the same ODBC driver with has no problems with it. It is just OOo that has this.