You must configure how the IBM® Db2® connector operates in a job
when writing data.
You must configure a database connection for the Db2 connector.
- On the job design canvas, double-click the Db2 connector icon.
- Click the Input tab, then select
the input link that you want to edit.
- Click the Properties tab.
- Specify the Write mode.
- 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.
- Specify whether you want SQL statements generated at
run time in the Generate SQL field.
- 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.
- In the SQL field, specify the
appropriate SQL statements.
- 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.
- In the Before or After SQL field,
specify whether an SQL statement runs before or after data processing.
- Click OK.