A data query execution executes an SQL Query against a database for each row of the input flow to transform it, and create a new data flow. Data from the input flow can be used as parameter.
-
Select the Data Query Execution tool in the palette, and create the action in the diagram.
-
Select the Data Flow tool, and draw a flow from the preceding step (a data input or action) to the data query execution.
-
Double-click the data query execution symbol to open its property sheet, click the Script tab, and select a data connection to access the database.
-
Enter an SQL query script in the textbox or click the Edit SQL Query tool to select PDM objects in the SQL Editor, and build the script.
-
Click the Retrieve Columns by Parsing Query tool that lets you parse the query you have specified in the textbox using the SQL Editor. The columns of the query are automatically created in the Data Structure Columns tab, and their parent tables or views are displayed in the Data Structure Source Objects tab.
-
[optional] Click the Data Structure Columns tab, and add, edit, reorder or delete columns as appropriate.
-
Click OK to save your changes and return to the diagram.