Skip to Content
0

I would like to set the return value from procedure to the item in HANA Calculation View.

May 25, 2017 at 06:31 AM

57

avatar image

Could you tell me how to set the return value which is the result of the SQL execution from passing from input parameter to procedure into the specific item in HANA Calculation View?

10 |10000 characters needed characters left characters exceeded

Hello Kenji,

please can you explain a little bit more what you are trying to do? Your "one sentence" question is not really enough to understand that.

E.g. are you trying to consume a procedure directly in a calc. view (which is not possible) or via a table function which can be used as data source.

Regards,
Florian

0

Thank you for the response. What I would like to do is in thebelow.

Call procedure with input parameter in the calculationview,

then set the return value which is the executionresult of the procedure

to a specific item in the calculation view.

0

As already mentioned, you can do that with a table function in which you can call a (read-only) procedure. Please try that way and in case of any issues, post your issues.

0

Hello Kenji

Could you please elaborate on your question. It sounds confusing. Do you want to call a procedure with input parameter inside a calculation view?

0

Thank you for the response. What I would like to do is in thebelow.

Call procedure with input parameter in the calculationview,

then set the return value which is the executionresult of the procedure

to a specific item in the calculation view.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers