Executing a custom SQL script

The SQL Operation action allows you to define and execute a custom SQL script within a macro or workflow on a defined database connection.

On the Configuration tab:

1. Enter the SQL statement.

2. Click Preview SQL to view the SQL statement with call substitutions to be made.

Possible applications include:

• Copy and paste your existing SQL scripts into Data Guru for integration with Data Guru actions and improved documentation.
• Manually type any SQL statements to perform desired operations, such as database maintenance operations.

Execute a SQL script

1. Drag the SQL Operation icon onto the design surface.
2. On the Connections tab tab , enter a Name and a Description to identify this action, then specify the database:
   • Database Connection – Select the target database on which the SQL statement is being run, or choose New Database Connection to establish a new connection.
3. On the Configuration tab :
   • For Call Definition, specify the SQL statement to be executed.
   • Click Preview SQL to view the SQL statement to be called.