DB2 Table Consumer

DB2 Table Consumer (com.sap.dh.ds.db2.table.consumer) is based on system.externalOperator and uses datahub-flowagent for execution.

Configuration Parameters

Parameter	Type	Description
DB2 Connection	object	The object containing the connection parameters to a DB2 database. DB2 version (type enum) DB2 version. Default: DB2 UDB 11.x) Host (type string) DB2 host. Port (type number) DB2 port. Database name (type string) DB2 database name. User (type string) DB2 user. Password (type string) DB2 password. Additional Session Parameters (type string) Set session parameters which will affect the connection with the source.
Source Table	string	DB2 table name from which the data will be read, usually in <Schema>.<TableName> format.
Additional Session Parameters	string	Set session parameters which will affect the connection with the source.
Partition Type	string	Partitioning is used to enable data reading in parallel. In this case, the producer must be inside a group with multiplicity equal to the number of partitions (only the producer, i.e., Flowagent File Producer). For more information about partitioning, check the documentation presented in the demo graph Ingest DB2 via SQL. Default: None

Input

Input	Type	Description
`inTableName`	string	SQL Server table name from which the data will be read, usually in <Schema>.<TableName> format Note This is optional. If Source Table is presented, this port is ignored.

Output

Output	Type	Description
`outConfig`	string.flowagent.config	Flowagent type port, which only `Flowagent producers` can consume (i.e., Flowagent File Producer). In order to get the data as string, `Flowagent CSV Producer`can be used as producer.
`outError`	string	Operator error. If mapped, the operator error will be sent to the operator this port is mapped to and the graph will remain running. If not mapped, the graph will terminate with the operator error.