Output
IBM DB2 Output
Writes the rows that reach it into an existing IBM DB2 table, in one transaction, and passes them on unchanged.
When to use it
Use it to load staged data into DB2 — a staging table for a batch job, or reference data from a spreadsheet.
In a pipeline
Excel InputRename ColumnIBM DB2 Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Target Table | select | Yes | Select a table |
| Write Mode | select | — | append |
| Key columns | select | — | Columns that identify a row |
Example
Load new rates
- Target Table=STAGE.RATES
- Write Mode=Upsert
- Key columns=RATE_CODE
| RATE_CODE | RATE |
|---|---|
| STD | 0.042 |
| PREF | 0.035 |
| RATE_CODE | RATE |
|---|---|
| STD | 0.042 |
| PREF | 0.035 |
Worth knowing
- All of a node's statements run in one transaction: if any insert fails, nothing changes.
- Upsert deletes the incoming keys first, then inserts, in the same transaction.
- Previews never write.