ODBC driver for SAP ASE

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
nohez
Posts: 2
Joined: Mon 28 May 2018 05:24

ODBC driver for SAP ASE

Post by nohez » Mon 28 May 2018 05:37

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,

Stellar
Devart Team
Posts: 152
Joined: Tue 03 Oct 2017 11:00

Re: ODBC driver for SAP ASE

Post by Stellar » Wed 13 Jun 2018 08:22

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.

nohez
Posts: 2
Joined: Mon 28 May 2018 05:24

Re: ODBC driver for SAP ASE

Post by nohez » Wed 13 Jun 2018 11:13

Ok. Please update me when you address the rounding of large values in money datatype. I will then continue my evaluation.

MaximG
Devart Team
Posts: 1120
Joined: Mon 06 Jul 2015 11:34

Re: ODBC driver for SAP ASE

Post by MaximG » Tue 17 Jul 2018 12:18

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

Post Reply