Defining properties for reading data

You must configure how the IBM® Db2® connector operates in a job when reading data.

Before you begin

You must configure a database connection for the Db2 connector.


  1. On the job design canvas, double-click the Db2 Connector stage icon.
  2. Click the Output tab, then select the output link that you want to edit.
  3. Click the Properties tab.
  4. On the Properties tab in the Usage section, specify how the connector operates in a job.
    1. Specify whether you want SQL statements generated at run time in the Generate SQL field.
    2. In the Table field, specify the table that you want to read.
    3. In the Enable quoted identifiers field, specify Yes to retain the case of all of the object names in DDL and DML statements.
      The default is No.
    4. In the Before or After SQL field, specify whether an SQL statement runs before or after data processing.
  5. Click OK to save.