Database Ingestion and Replication > Default data-type mappings > Db2 for z/OS Source and Databricks Target
  

Db2 for z/OS Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for z/OS source and a Databricks target:
Db2 for z/OS Source Data Type
Databricks Target Data Type
bigint
long
binary(size), 1 <= size <= 255
binary
char for bit data
binary
char(size) for bit data, 2 <= size <= 255
binary
char(size), 1 <= size <= 255
string
date
string
decfloat(precision), 16 <= p <= 34
string
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
float
double
integer
integer
long varchar
string
long varchar for bit data
binary
real
float
rowid
binary
smallint
integer
time
string
timestamp(precision) with time zone, 0 <= p <= 12
string
timestamp(precision), 0 <= p <= 6
timestamp
timestamp(precision), 7 <= p <= 12
string
varbinary(size), 1 <= size <= 32704
binary
varchar(size) for bit data, 1 <= size <= 32704
binary
varchar(size), 1 <= size <= 32704
string
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for z/OS data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.