Introduction

...

User Facing Name	Type	Description	Constraints
Label	String	Label for UI
Reference Name	String	Uniquely identified name for lineage
Host	String	DB2 host	Required (defaults to localhost on UI)
Port	Number	Specific port which DB2 is listening to	Optional (default 50000)
Database	String	Database name to connect	Required
Username	String	DB username	Required
Password	Password	User password	Required
Transaction Isolation Level	Select	Transaction isolation level for queries run by this sink
Connection Arguments	Keyvalue	A list of arbitrary string tag/value pairs as connection arguments, list of properties: DB2 connection properties
Table Name	String	Name of a database table to write to

...

DB2 Data Type	CDAP Schema Data Type	Support	Comment
SMALLINT	Schema.Type.INT	+
INTEGER	Schema.Type.INT	+
BIGINT	Schema.Type.LONG	+
DECIMAL(p,s) or NUMERIC(p,s)	Schema.LogicalType.DECIMAL	+
DECFLOAT	Schema.LogicalTypeType.DECIMALSTRING	+
REAL	Schema.Type.FLOAT	+
DOUBLE	Schema.Type.DOUBLE	+
CHAR	Schema.Type.STRING	+
VARCHAR	Schema.Type.STRING	+
CHAR(n) FOR BIT DATA	Schema.Type.BYTES	+
VARCHAR(n) FOR BIT DATA	Schema.Type.BYTES	+
BINARY	Schema.Type.BYTES	+
VARBINARY	Schema.Type.BYTES	+
GRAPHIC	Schema.Type.STRING	+
VARGRAPHIC	Schema.Type.STRING	+
CLOB	Schema.Type.STRING	+
BLOB	Schema.Type.BYTES	+
DBCLOB	Schema.Type.STRING	+
ROWID		-	Not all flavors of DB2 support this type
XML		-	Not all flavors of DB2 support this type
DATE	Schema.LogicalType.DATE	+
TIME	Schema.LogicalType.TIME_MICROS	+
TIMESTAMP	Schema.LogicalType.TIMESTAMP_MICROS	+

...

Versions Compared