SQL Scripts

How can we write and execute sql scripts directly from Process Studio?

Hi Pranjal,

Execute SQL script Plugin can be used to execute SQL queries from Process Studio.
Script can be executed either once, during the initialization phase of the workflow, or once for every input-row to the step. Because of the dynamic nature of the step, it does not use prepared statements.