Skip to Content
avatar image
Kabilarasan R

How to access HANA Procedure From Information Design Tool(IDT)

Sep 06, 2017 at 12:57 PM | 44 Views

Hi Friends...

i'm Trying to access my Store Procedure in hana from IDT.. But i can't... i can see the tables, views, and Table Types but Store Procedure is not available to access..

Is there is anyway to access it...

SAP HANA Enterprise Cloud
BW SAP HANA Modeling Tools (Eclipse) | SAP HANA | idt
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Kabilarasan R
    Sep 07, 2017 at 06:54 AM

    Hi Experts,

    I got an answer for my question.

     WITH RESULT VIEW <view_name> <view_name> ::= <identifier>

    It Specifies the result view to be used as the output of a read-only procedure.

    Example 2 - Creating an SQL Procedure with Result View:

    createprocedure"KABIL_PRACTICE"."ARRAY_UNNEST_SIMPLE_With_Result_View"(OUT result "KABIL_PRACTICE"."TTYPE")
LANGUAGE SQLSCRIPT READS SQL DATA with result view "KABIL_PRACTICE"."ARRAY_UNNEST_RES"
as begin 
declare ID integer array :=array(1,2);
declare NAME nvarchar(65) array := Array ('name1','name2','name3');
result = UNNEST(:ID,:NAME);
end;

    To Call a Procedure:

    select * from"KABIL_PRACTICE"."ARRAY_UNNEST_SIMPLE_With_Result_View"

    And then Open your Information design Tool (IDT) there you may get the result of the procedure as in a "View name " which is you mentioned in your procedure under your schema....

    thank you...

    Add comment
    10|10000 characters needed characters exceeded