SAP HANA Limitations

[Former Member]

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

[lucas_oliveira]

Hi Dennis,

I'm not sure what exactly you meant with point 1. I'm assuming you need to run a database procedure with more than one output. If that's the case this is perfectly fine. You can write procedures with more than one output, like (dummy example alert):

create type T_SBOOK as table (FLDATE VARCHAR(8), FORCURAM DECIMAL(15,2));
create procedure ZAZ (out out1 T_SBOOK, out out2 T_SBOOK) as
begin
	out1 = select FLDATE, SUM(FORCURAM) as FORCURAM from SAPABAP1.SBOOK group by FLDATE;
	out2 = select FLDATE, SUM(FORCURAM) as FORCURAM from ANOTHERSCHEMA.SBOOK group by FLDATE;
end;

Then your variables out1 and out2 would have the values from the queries on different schemas.

If that's not what you're looking for, please specify with as much details as possible so we can try to help.

BRs,

Lucas de Oliveira