ODBC driver for SAP ASE
Posted: 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,
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,