Reading data

To read data from a Db2 table by using the Db2® connector, you configure the Db2 connector to process data as a source. The Db2 connector runs an SQL statement and returns the results as a set of zero or more rows. In the source context, the connector extracts or reads data from an external Db2 data source.

The following figure shows an example of using the Db2 connector to read data. In this case, the Db2 connector reads data and then loads it from DB2_Connector_1 into DB2_Connector_2. When you configure the Db2 connector to read data, you create only one output link, which is shown in the figure below transferring rows from DB2_Connector_1 to DB2_Connector_2.
Figure 1. Example of reading data
The figure shows an example of using the Db2 connector to read data.