Skip to Content
0
Former Member
Nov 03, 2016 at 02:44 PM

SAP HANA Limitations

178 Views Last edit Nov 15, 2016 at 02:37 PM 2 rev

Hello,

While migrating SQL Server queries to SAP HANA, I came across two issues:

1) I have a query which needs to return results from more than one table. This type of query works with SQL server but does not work on SAP HANA. I am using sqlDataAdapter for SQL Server and hanaDataAdapter for SAP HANA to execute queries from ASP.Net code. Please refer the below example:

Select * from table1; Select * from table2

Is there any way to make this work on SAP HANA?

2) I need to pass a table field in a User Defined function. However I found the following post which states that it is not supported in SAP HANA.

https://archive.sap.com/discussions/thread/3424695

Since the above post is old, Could you let me know if there is any solution for this yet?

Thanks