Question Re: run flowgraph from a procedure in Technology Q&A

run flowgraph from a procedure

Eisson — Fri, 04 Jun 2021 22:40:13 GMT

hello community,

I am currently exploring the objects in Business Application Studio and some questions arose which I do not know if I have searched in the correct way.

The questions are:

how can I execute a flowchart from a hdbprocedure?

and in a hdbprocedure can another procedure be executed?

Example, I have FG_PRUEBA.hdbflowgraph and I need to activate it when I run the procedure SP_FGEXECU.hdb

or create a schedule for the flowgraph

Thank you for your answers

Bests regards

Re: run flowgraph from a procedure

werner_daehn — Sat, 05 Jun 2021 17:04:41 GMT

The hdbflowgraph is the designtime object. When activated, one or two tasks and Hana stored procedures are created. And these can be called from SQL.

Give it a try. I the flowgraph editor, there is the option to run a flowgraph. This will show you the SQL command to execute.

Note: I am talking with the XSC or XSA editor in mind. Not sure if something changed with BAS.

Re: run flowgraph from a procedure

detakeo — Tue, 08 Jun 2021 18:45:23 GMT

Create a Hana scheduler with the task that you have created(flow graphs or any tasks).

CALL "<package_name>::<flowgraph_name>_SP"

You can also do it using REST APIs.