Devart DB2 Source is a data flow component that makes data from DB2 available to other data flow components. It provides a convenient editor dialog box, which allows you to easily define which data to load.

To call the Devart DB2 Source Editor, double-click the Devart DB2 Source data flow object.

This dialog box has the following components:

• The Tables area allows you to view the existing DB2 tables, expand their nodes to view columns, and drag them from this area to the Query area.

  • The Show all schemas button enables displaying all the objects of the selected connection; otherwise, only the objects of the default schema for the connection are displayed.
  • The Refresh Objects button updates the list of DB2 tables.
• The Variables area allows you to view the system and user variables grouped in the corresponding nodes, and if necessary, drag them to the Query area.

• The Query area is intended for creating a query to be executed against the DB2 database. You can drag the required DB2 tables and variables to this area, or write the query yourself.

  • The Preview Data button calls the Preview Data window that displays the query execution result.
• The Properties area displays properties of the currently selected DB2 table, column or variable.
• The DB2 Connection drop-down list is intended for selecting the corresponding Devart DB2 Connection Manager.