Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 22 at 10:38 AM

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

    Add comment
    10|10000 characters needed characters exceeded