Defining properties for writing data

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

Before you begin

You must configure a database connection for the Db2 connector.

Procedure

  1. On the job design canvas, double-click the Db2 connector icon.
  2. Click the Input tab, then select the input link that you want to edit.
  3. Click the Properties tab.
    1. Specify the Write mode.
    2. In the Table name field, specify the name of the destination table that is used in the SQL statements that are meant for writing data.
      For the write mode, the table must exist. You can create the table at runtime using the Create or Replace table actions. The table name is used to generate Data Definition Language (DDL) statements. You must specify a table name if Write mode is set to Bulk Load, the Generate SQL property is set to Yes, or the Table action property is set to Create, Drop, or Truncate.
    3. Specify whether you want SQL statements generated at run time in the Generate SQL field.
    4. 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.
    5. In the SQL field, specify the appropriate SQL statements.
    6. In the Table action field, specify how you want tables to be created, or how you want rows to be edited or inserted in an existing destination table.
    7. In the Before or After SQL field, specify whether an SQL statement runs before or after data processing.
  4. Click OK.