Database Ingestion and Replication > Default data-type mappings > Db2 for i Source and Google BigQuery Target
  

Db2 for i Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Db2 for i source and a Google BigQuery target:
Db2 for i Source Data Type
Google BigQuery Target Data Type
bigint
int64
binary(size), 1 <= size <= 32766
bytes
char(size) for bit data, 1 <= size <= 32766
bytes
char(size), 1 <= size <= 32766
string
date
date
decfloat(precision), 16 <= p <= 34
string
decimal(1,1)
numeric
decimal(10,10)
bignumeric
decimal(11,s), 10 <= s <= 11
bignumeric
decimal(12,s), 10 <= s <= 12
bignumeric
decimal(13,s), 10 <= s <= 13
bignumeric
decimal(14,s), 10 <= s <= 14
bignumeric
decimal(15,s), 10 <= s <= 15
bignumeric
decimal(16,s), 10 <= s <= 16
bignumeric
decimal(17,s), 10 <= s <= 17
bignumeric
decimal(18,s), 10 <= s <= 18
bignumeric
decimal(19,s), 10 <= s <= 19
bignumeric
decimal(2,s), 1 <= s <= 2
numeric
decimal(20,s), 10 <= s <= 20
bignumeric
decimal(21,s), 10 <= s <= 21
bignumeric
decimal(22,s), 10 <= s <= 22
bignumeric
decimal(23,s), 10 <= s <= 23
bignumeric
decimal(24,s), 10 <= s <= 24
bignumeric
decimal(25,s), 10 <= s <= 25
bignumeric
decimal(26,s), 10 <= s <= 26
bignumeric
decimal(27,s), 10 <= s <= 27
bignumeric
decimal(28,s), 10 <= s <= 28
bignumeric
decimal(3,s), 1 <= s <= 3
numeric
decimal(4,s), 1 <= s <= 4
numeric
decimal(5,s), 1 <= s <= 5
numeric
decimal(6,s), 1 <= s <= 6
numeric
decimal(7,s), 1 <= s <= 7
numeric
decimal(8,s), 1 <= s <= 8
numeric
decimal(p,0), 1 <= p <= 18
int64
decimal(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
decimal(p,s), 29 <= p <= 48, 0 <= s <= 29
bignumeric
decimal(p,s), 30 <= p <= 49, 0 <= s <= 30
bignumeric
decimal(p,s), 31 <= p <= 50, 0 <= s <= 31
bignumeric
decimal(p,s), 32 <= p <= 51, 0 <= s <= 32
bignumeric
decimal(p,s), 33 <= p <= 52, 0 <= s <= 33
bignumeric
decimal(p,s), 34 <= p <= 53, 0 <= s <= 34
bignumeric
decimal(p,s), 35 <= p <= 54, 0 <= s <= 35
bignumeric
decimal(p,s), 36 <= p <= 55, 0 <= s <= 36
bignumeric
decimal(p,s), 37 <= p <= 56, 0 <= s <= 37
bignumeric
decimal(p,s), 38 <= p <= 56, 0 <= s <= 38
bignumeric
decimal(p,s), 39 <= p <= 40, 0 <= s <= 39
string
decimal(p,s), 39 <= p <= 40, 21 <= s <= 38
bignumeric
decimal(p,s), 40 <= p <= 41, 0 <= s <= 40
string
decimal(p,s), 41 <= p <= 42, 0 <= s <= 41
string
decimal(p,s), 42 <= p <= 43, 0 <= s <= 42
string
decimal(p,s), 43 <= p <= 44, 0 <= s <= 43
string
decimal(p,s), 44 <= p <= 63, 0 <= s <= 44
string
decimal(p,s), 45 <= p <= 46, 0 <= s <= 45
string
decimal(p,s), 46 <= p <= 47, 0 <= s <= 46
string
decimal(p,s), 47 <= p <= 48, 0 <= s <= 47
string
decimal(p,s), 48 <= p <= 49, 0 <= s <= 48
string
decimal(p,s), 49 <= p <= 50, 0 <= s <= 49
string
decimal(p,s), 50 <= p <= 51, 0 <= s <= 50
string
decimal(p,s), 51 <= p <= 52, 0 <= s <= 51
string
decimal(p,s), 52 <= p <= 53, 0 <= s <= 52
string
decimal(p,s), 53 <= p <= 54, 0 <= s <= 53
string
decimal(p,s), 54 <= p <= 55, 0 <= s <= 54
string
decimal(p,s), 55 <= p <= 56, 0 <= s <= 55
string
decimal(p,s), 56 <= p <= 57, 0 <= s <= 56
string
decimal(p,s), 56 <= p <= 63, 39 <= s <= 62
string
decimal(p,s), 57 <= p <= 58, 0 <= s <= 57
string
decimal(p,s), 58 <= p <= 59, 0 <= s <= 58
string
decimal(p,s), 59 <= p <= 60, 0 <= s <= 59
string
decimal(p,s), 60 <= p <= 61, 0 <= s <= 60
string
decimal(p,s), 61 <= p <= 62, 0 <= s <= 61
string
decimal(p,s), 62 <= p <= 63, 0 <= s <= 62
string
decimal(p,s), 9 <= p <= 38, 1 <= s <= 9
numeric
float
float64
integer
int64
long varbinary
bytes
long varchar
string
long varchar for bit data
bytes
numeric(1,1)
numeric
numeric(10,10)
bignumeric
numeric(11,s), 10 <= s <= 11
bignumeric
numeric(12,s), 10 <= s <= 12
bignumeric
numeric(13,s), 10 <= s <= 13
bignumeric
numeric(14,s), 10 <= s <= 14
bignumeric
numeric(15,s), 10 <= s <= 15
bignumeric
numeric(16,s), 10 <= s <= 16
bignumeric
numeric(17,s), 10 <= s <= 17
bignumeric
numeric(18,s), 10 <= s <= 18
bignumeric
numeric(19,s), 10 <= s <= 19
bignumeric
numeric(2,s), 1 <= s <= 2
numeric
numeric(20,s), 10 <= s <= 20
bignumeric
numeric(21,s), 10 <= s <= 21
bignumeric
numeric(22,s), 10 <= s <= 22
bignumeric
numeric(23,s), 10 <= s <= 23
bignumeric
numeric(24,s), 10 <= s <= 24
bignumeric
numeric(25,s), 10 <= s <= 25
bignumeric
numeric(26,s), 10 <= s <= 26
bignumeric
numeric(27,s), 10 <= s <= 27
bignumeric
numeric(28,s), 10 <= s <= 28
bignumeric
numeric(3,s), 1 <= s <= 3
numeric
numeric(4,s), 1 <= s <= 4
numeric
numeric(5,s), 1 <= s <= 5
numeric
numeric(6,s), 1 <= s <= 6
numeric
numeric(7,s), 1 <= s <= 7
numeric
numeric(8,s), 1 <= s <= 8
numeric
numeric(p,0), 1 <= p <= 18
int64
numeric(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
numeric(p,s), 29 <= p <= 48, 0 <= s <= 29
bignumeric
numeric(p,s), 30 <= p <= 49, 0 <= s <= 30
bignumeric
numeric(p,s), 31 <= p <= 50, 0 <= s <= 31
bignumeric
numeric(p,s), 32 <= p <= 51, 0 <= s <= 32
bignumeric
numeric(p,s), 33 <= p <= 52, 0 <= s <= 33
bignumeric
numeric(p,s), 34 <= p <= 53, 0 <= s <= 34
bignumeric
numeric(p,s), 35 <= p <= 54, 0 <= s <= 35
bignumeric
numeric(p,s), 36 <= p <= 55, 0 <= s <= 36
bignumeric
numeric(p,s), 37 <= p <= 56, 0 <= s <= 37
bignumeric
numeric(p,s), 38 <= p <= 56, 0 <= s <= 38
bignumeric
numeric(p,s), 39 <= p <= 40, 0 <= s <= 39
string
numeric(p,s), 39 <= p <= 40, 21 <= s <= 38
bignumeric
numeric(p,s), 40 <= p <= 41, 0 <= s <= 40
string
numeric(p,s), 41 <= p <= 42, 0 <= s <= 41
string
numeric(p,s), 42 <= p <= 43, 0 <= s <= 42
string
numeric(p,s), 43 <= p <= 44, 0 <= s <= 43
string
numeric(p,s), 44 <= p <= 63, 0 <= s <= 44
string
numeric(p,s), 45 <= p <= 46, 0 <= s <= 45
string
numeric(p,s), 46 <= p <= 47, 0 <= s <= 46
string
numeric(p,s), 47 <= p <= 48, 0 <= s <= 47
string
numeric(p,s), 48 <= p <= 49, 0 <= s <= 48
string
numeric(p,s), 49 <= p <= 50, 0 <= s <= 49
string
numeric(p,s), 50 <= p <= 51, 0 <= s <= 50
string
numeric(p,s), 51 <= p <= 52, 0 <= s <= 51
string
numeric(p,s), 52 <= p <= 53, 0 <= s <= 52
string
numeric(p,s), 53 <= p <= 54, 0 <= s <= 53
string
numeric(p,s), 54 <= p <= 55, 0 <= s <= 54
string
numeric(p,s), 55 <= p <= 56, 0 <= s <= 55
string
numeric(p,s), 56 <= p <= 57, 0 <= s <= 56
string
numeric(p,s), 56 <= p <= 63, 39 <= s <= 62
string
numeric(p,s), 57 <= p <= 58, 0 <= s <= 57
string
numeric(p,s), 58 <= p <= 59, 0 <= s <= 58
string
numeric(p,s), 59 <= p <= 60, 0 <= s <= 59
string
numeric(p,s), 60 <= p <= 61, 0 <= s <= 60
string
numeric(p,s), 61 <= p <= 62, 0 <= s <= 61
string
numeric(p,s), 62 <= p <= 63, 0 <= s <= 62
string
numeric(p,s), 9 <= p <= 38, 1 <= s <= 9
numeric
real
float64
rowid
bytes
smallint
int64
time
time
timestamp(precision), 0 <= p <= 6
datetime
timestamp(precision), 7 <= p <= 12
string
varbinary(size), 1 <= size <= 32740
bytes
varchar(size) for bit data, 1 <= size <= 32740
bytes
varchar(size), 1 <= size <= 32740
string
Unsupported source data types
Database Ingestion and Replication does not support the following Db2 for i data types:
Database ingestion and replication jobs propagate nulls for columns that have these data types.