Writing data

To write data to a Db2® table by using the Db2connector, you configure the Db2 connector to process data as a target. The Db2 connector runs an SQL statement and returns the results as a set of zero or more rows. In the target context, the connector connects to the external Db2 data source and inserts, updates, or deletes data as required.

The following figure shows an example of using the Db2 connector to write data. In this case, the Db2 connector reads data from DB2_Connector_1 and then loads the data into DB2_Connector_2. The Db2 connector then inserts, updates, or deletes data into DB2_Connector_2 as required.
Figure 1. Example of writing data
The figure shows an example of using the Db2 connector to write data.