on 02-28-2018 1:10 AM
Hello experts,
We just created a Virtual table on an SDA connection over a SQL server view which consists of a SELECT containing few fields and a couple of them derived from a function call (returning "money" type value), defined like this:
create view zvw_mysql_view as(
select
my_date,<br> my_docnr,<br> my_line,<br> my_kf001,<br> my_kf002,<br> (call function my_function(my_date)) as exchange_rate
from dbo.some_table);
field "exchange_rate" receives the "my_function" output which in SQL server is a "money" type...
At the Virtual table side I expect to get lines like these:
my_date my_docnr my_line my_kf001 my_kf002 exchange_rate
20180201 100001 1 100 1810 18.10
20180202 100002 2 100 1980 19.80
however I am getting "exchange_rate" as:
my_date my_docnr my_line my_kf001 my_kf002 exchange_rate
20180201 100001 1 100 1800 18
20180202 100002 2 100 1900 19
Any suggestions? Is virtual table fully compatible with SQL server money and/or function calls from selects/views? any workaround?
Any clue is welcome.
Thanks in advance.
Cheers
Bernardo
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.