Skip to Content

Input Parameter for procedure in HANA SDI Flowgraph

Im using a procedure in HANA SDI flowgraphs and when I try connecting procedure with other node, it's asking for Input parameter. My procedure is a simple one with out any input/output parameters and all it does is deleting the data from a HANA table. How do I get around with this input parameter?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 08 at 03:03 PM

    I'm having a hard time understanding the scenario. Can you supply some screenshots of the whole flowgraph as well as the details within the Procedure Node?

    If it needs an input table, you could put in a data source of the table that will be deleted. If it needs an input value of some kind, you can create a variable in the flowgraph and use that as the input.

    Regards,

    Jeff K

    Add comment
    10|10000 characters needed characters exceeded

  • May 08 at 03:30 PM

    Procedure:

    CREATE PROCEDURE "TEST"."Y_TEST_PROC"

    LANGUAGE SQLSCRIPT SQL SECURITY INVOKER AS

    --DEFAULT SCHEMA <default_schema_name>

    --READS SQL DATA AS

    BEGIN

    DELETE FROM "TEST"."ABC.TABLES::ARREARS" WHERE "MEG" = 'N';

    end;

    Add comment
    10|10000 characters needed characters exceeded

  • May 08 at 03:30 PM

    I did create variable of type both expression and scalar, but I dont see them for selection in input parameter. INput parameter selection is not enabled.

    Add comment
    10|10000 characters needed characters exceeded