Skip to Content
0

Input Parameter for procedure in HANA SDI Flowgraph

May 08 at 02:53 PM

94

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jeff Kresse
May 08 at 03:03 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 08 at 03:30 PM
0

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;


Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 08 at 03:30 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded