Chapter 10 Building Data Transformation Diagrams

Inserting a data query execution

A data query execution represents the execution of an SQL Query in the database for each row of the incoming flow to create a new data flow.

You use a data query execution in order to select, insert or update data in a given database. Data from the incoming flow may be used as parameter.

You need to select a data connection to get access to the database and define a SQL Query in the Script tab.

You can modify the data structure columns of a data query execution.

To insert a data query execution:

1. Select the Data Query Execution tool in the palette, and create the corresponding object in the diagram.
2. Select the Data Flow tool, and draw a flow from the preceding step (a data input or action) to the data query execution to initialize it with the appropriate columns.
3. Double-click the data query execution symbol to open its property sheet. The Data Structure Columns tab is automatically completed with the values from the incoming flow.
4. Click the Data Structure Columns tab and do any appropriate changes.
5. Click the Script tab, and select a data connection to get access to the database from the Data Connection list, and type a SQL query in the textbox.
   
6. Click OK to save your changes and return to the diagram.

Copyright (C) 2007. Sybase Inc. All rights reserved.