Skip to Content
0

Create a Calculation view that reads a table function as data source

Feb 22 at 09:34 AM

80

avatar image

Hi experts.


I'm building a test calculation view that reads from a table function:

create function "tableFunction" ()
Returns table ( "nu1" integer, "na" NVARCHAR(35), "nu2" integer)
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER AS
BEGIN
RETURN
SELECT "E_ID" as "nu1", "E_NAME" AS "na", "E_OVERTIME" as "nu2" FROM "OVERTIME";
END;

The fact is that the function works fine and it returns that test table, but i have a problem when i try to read it in the calc view:

Could you help me to solve this error or if it is not possible to do this. How could I read from a procedure or something that allows me to clean data before load it on hana?

Thanks in advance.

tablefunction.png (75.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lars Breddemann
Feb 22 at 10:38 AM
0

Use a table function that was defined as a repository object.

Show 5 Share
10 |10000 characters needed characters left characters exceeded

Please could you tell me how do i do this or where can i see documentation about it ?

0

Checked the developer guides?

1

I think that not, could you indicate what are the guides for this issue of table functions? One friend told me about define a table structure and return it in instead of the table. I will chek it as soon as I will have time.

0

https://help.sap.com has got the whole HANA documentation including all developer guides.

Once you got the time, just use your google skills to find the specific topic.

0

Finally was that, a lot of thanks

0