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: 99
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.

Post Reply