Skip to Content
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


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.

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