cancel
Showing results for 
Search instead for 
Did you mean: 

Input Parameter for procedure in HANA SDI Flowgraph

0 Kudos

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?

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

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.

former_member231709
Active Contributor
0 Kudos

Hi, did you solve your problem?

0 Kudos

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;

jeffrey_kresse
Employee
Employee
0 Kudos

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