DataFlux Data Management Studio 2.5: User Guide

Parameterized SQL Query Node

You can add a Parameterized SQL Query node to a data job to write an SQL query that contains variable inputs, also known as parameters. Each parameter in the query is represented by a question mark. When a row of data is processed, the parameters are replaced with the values of the input fields that have been designated as parameter inputs, and the query is executed.

The output of this node includes all of the fields from its parent, plus any fields designated as output fields from the query. If the query does not return any data, the output of the node will just be its parent's fields. If the query returns multiple rows of data, they will all be written to the output, unless the option for single row output is selected.

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 input.

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 sources that have been identified on your computer through the Microsoft® Windows® ODBC Data Source Administrator dialog.

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.

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

The Input fields section of the dialog includes the following elements:

Available - Displays the fields that you can make available for the next step in your data job. Items displayed in this list are dependent on your data sources and any preceding steps in your data job.

Selected - Displays the fields that will be made available to the next node in your data job.

The Output fields section of the dialog includes the following elements:

Output Fields Table - Specifies the list of output fields from the SQL query that will be included in the output data of this node. The fields are written to the output in the order in which they appear in the grid. The number and order of fields in the grid does not need to match the number and order of fields returned by this node's SQL query. Click Add to add fields to the table. Use the arrow keys and delete button as needed.

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

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfU_PFUtil_ParamSQL.html