DataFlux Data Management Studio 2.6: User Guide

SQL Execute Node

You can add an SQL Execute node to a data job to construct and execute any valid SQL statement (or series of statements). Once you have added the node, you can double-click it to open its properties dialog. The properties dialog includes the following elements:

Name - Specifies a name for the node.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the node.

Data Source - Lists the data sources that have been identified on your computer. You can click Refresh to update the list after you make changes. You can also click ODBC Administrator and DataFlux Connection Administrator to configure databases.

The Query section of the properties dialog includes the following elements:

Query Table - Displays the SQL statements that are available for execution.

Add - Adds an SQL statement to the list of SQL statements.

Edit - Opens a window with a free-form text entry field so you can edit the selected SQL statement. Query can also be launched from this window.

Delete - Enables you to remove the selected SQL statement from the QueryTable.

Check Syntax - Enables you to test the syntax of the selected SQL statement.

Load - Enables you to import multiple SQL statements from a text file. Browse to the text file with the SQL statements and the SQL statements will be parsed one SQL statement per line from the text file and will be loaded into SQL Execute step.

Save - Stores a selected SQL statement from the list of SQL statements in the SQL Execute node to a text file.

Save All - Saves all the SQL statements to a text file to be restored later.

Note: When you use a custom connection with an SQL node such as SQL Query and SQL Execute, we strongly recommend that you fully qualify table names by using the catalog.schema.table syntax.

You can access the following advanced properties by right-clicking the SQL Execute node:

• DSN
• STATEMENTS