Input
IBM DB2 Input
Reads a whole table or view from an IBM DB2 database (LUW or Db2 on Cloud) and turns it into rows.
When to use it
Use it for ERP, banking or insurance data kept in DB2 — a nightly extract, or a reference table to join against.
In a pipeline
IBM DB2 InputFilter RowsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Table | select | Yes | Select a table |
Example
Policy extract
- Connection=db2inst1@db2.example.com/POLICY
- Table=CORE.POLICIES
| POLICY_NO | HOLDER | PREMIUM |
|---|---|---|
| P-1001 | A. Rossi | 820 |
| P-1002 | J. Chen | 1140 |
Worth knowing
- Tables and views are listed as SCHEMA.NAME, without the SYS* catalogs.
- Plain names find upper-case objects, as DB2 folds them; mixed-case names are quoted exactly.
- Runs through the server's Python bridge (ibm_db, which brings IBM's client driver).