...
Action that runs a DB2 command. The action can be used whenever you want to run a DB2 command before or after a data pipeline. For example, you might want to run an SQL update
command on a database before the pipeline source pulls data from tables.
Configuration
Property | Macro Enabled? | Description |
---|---|---|
Driver Name | No | Required. Name of the JDBC driver to use. Default is db211. |
Host | Yes | Required. Host that DB2 is running on. Default is localhost. |
Port | Yes | Required. Port that DB2 is listening to. Default is 50000. |
Database | Yes | Required. DB2 database name. |
Database Command | Yes | Required. Database command to execute. |
Username | Yes | Optional. User identity for connecting to the specified database. |
Password | Yes | Optional. Password to use to connect to the specified database. |
Connection Argument | Yes | Optional. A list of arbitrary string key/value pairs as connection arguments. These arguments will be passed to the JDBC driver as connection arguments for JDBC drivers that may need additional configurations. |