Run SQL Node

The Run SQL node permits users to incorporate and execute custom SQL scripts of any type. It’s a stand-alone node that won’t connect to any other node. When it runs it is determined by the Run Order.

Unlike the Query node, the Run SQL node is not intended to interact directly with the records handled by the job it’s placed in. Rather, it’s intended to execute more “global” functions – say, creating or deleting a database table or editing values not dependent upon the job.

Note: This node will not be available until the user checks the "Allow SQL Commands on Database Connections" options box under the Tools > Options toolbar menu. Once checked and saved, any database connection capable of executing SQL script commands will have this option available.

To use the Run SQL node, select the SQL connection from the connections list by clicking on it, then the Run SQL node will become available for use indicated by its change in color from grey to green.