DataFlux Data Management Studio 2.7: User Guide

SQL Query Node

The SQL Query node specifies an SQL query that selects data from one or more tables. The results table is used an input in a data job. The properties dialog for this node contains 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 SQL query.

Data Source - Contains the Data Source drop-down list to select a data source to display the specific data tables available in that format. This list contains the data connections that have been identified on your computer.

Refresh - Updates the Select Table list after you make changes using the ODBC Data Source Administrator or DataFlux Connection. If you select a data source type that prompts you to select an associated file and then decide that you would rather select another data source, click Refresh to clear the file first selected.

Query - Provides space for you to enter an SQL query, either by direct entry in the Query text field or through the use of the Query Builder.

Query Builder - Enables you to access the Query Builder dialog. The output from the dialog is entered into the Query field.

Check Syntax - Evaluates the SQL syntax of the query entered in the Query field.

Note: You can enter SQL that is specific to the data source that is selected in the Data Source field above. For example, if you selected a SAS table that is accessed with a SAS Federation Server connection or a SAS Data Set Connection, you can enter Federation Server FedSQL, which is described in the SAS Federation Server FedSQL Reference Guide. If you selected a database table that is accessed with an ODBC connection, you could enter database-specific syntax. For more information, see the ODBC help in DataFlux Data Management Studio and also the documentation for the database.

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 also access the following advanced properties by right-clicking the SQL Query node in the data job:

• DSN
• MAX_OUTPUT_ROWS
• ROW_ESTIMATE
• SQL_PARAMETERS
• SQL_PROTOTYPE
• SQL_STMT
• TYPE_OVERRIDES