I am currently evaluating the Devart ODBC driver for SAP ASE on Linux using unixODBC v2.3.0 and ASE 16.0 SP02 PL03.
I am facing three problems.
1. querying datetime value gives incorrect results.
2. money values are rounded off to zero decimals.
3. column with NULL values are reported as blanks.
For eg:
SQL> create table #tmp (a datetime null, b money null, c char NULL)
SQLRowCount returns 0
SQL> insert #tmp values ('1 Apr 2018 1:00 PM', 922337203685477.5807, NULL)
SQLRowCount returns 1
SQL> select * from #tmp
+------------------------+----------------------+--+
| a | b | c|
+------------------------+----------------------+--+
| 18 13.000 | 922337203685478 | |
+------------------------+----------------------+--+
SQLRowCount returns -1
Is there any configuration required at driver level to correct the above?
Thanks & regards,
ODBC driver for SAP ASE
Re: ODBC driver for SAP ASE
1. Thank you for the information. We have fixed the issue with the display of DateTime field values, and the fix will be included in the next Devart ODBC driver for SAP ASE build.
2. Double has approximately 15 digits of accuracy, so the value of 922337203685477.5807 is rounded to 15 characters.
We will investigate the issue of rounding large values for the Money type, perhaps we will change the type to transfer large values.
3. UnixODBC for the "c" field that has the char type requests a value as a string, therefore, NULL is displayed as an empty value.
2. Double has approximately 15 digits of accuracy, so the value of 922337203685477.5807 is rounded to 15 characters.
We will investigate the issue of rounding large values for the Money type, perhaps we will change the type to transfer large values.
3. UnixODBC for the "c" field that has the char type requests a value as a string, therefore, NULL is displayed as an empty value.
Re: ODBC driver for SAP ASE
Ok. Please update me when you address the rounding of large values in money datatype. I will then continue my evaluation.
Re: ODBC driver for SAP ASE
On 16-Jul-18 we released a new version 1.4.8 that includes the changes you need. A full list of changes can be found by the link: https://www.devart.com/odbc/ase/revision_history.html