Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Db2 for i Source Data Type | Google BigQuery Target Data Type |
|---|---|
bigint | int64 |
binary( size ), 1 <= s <= 32766 | bytes |
char( size ) for bit data, 1 <= s <= 32766 | bytes |
char( size ), 1 <= s <= 32766 | string |
date | date |
decfloat( precision ), 16 <= p <= 34 | string |
decimal | int64 |
decimal(1) | int64 |
decimal(1,1) | numeric |
decimal(10) | int64 |
decimal(10,10) | bignumeric |
decimal(11) | int64 |
decimal(11,s), 10 <= s <= 11 | bignumeric |
decimal(12) | int64 |
decimal(12,s), 10 <= s <= 12 | bignumeric |
decimal(13) | int64 |
decimal(13,s), 10 <= s <= 13 | bignumeric |
decimal(14) | int64 |
decimal(14,s), 10 <= s <= 14 | bignumeric |
decimal(15) | int64 |
decimal(15,s), 10 <= s <= 15 | bignumeric |
decimal(16) | int64 |
decimal(16,s), 10 <= s <= 16 | bignumeric |
decimal(17) | int64 |
decimal(17,s), 10 <= s <= 17 | bignumeric |
decimal(18) | int64 |
decimal(18,s), 10 <= s <= 18 | bignumeric |
decimal(19,s), 10 <= s <= 19 | bignumeric |
decimal(2) | int64 |
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) | int64 |
decimal(3,s), 1 <= s <= 3 | numeric |
decimal(38,9) | numeric |
decimal(4) | int64 |
decimal(4,s), 1 <= s <= 4 | numeric |
decimal(40,s), 1 <= s <= 21 | bignumeric |
decimal(41,s), 2 <= s <= 22 | bignumeric |
decimal(42,s), 3 <= s <= 23 | bignumeric |
decimal(43,s), 4 <= s <= 24 | bignumeric |
decimal(44,s), 5 <= s <= 25 | bignumeric |
decimal(45,s), 6 <= s <= 26 | bignumeric |
decimal(46,s), 7 <= s <= 27 | bignumeric |
decimal(47,s), 8 <= s <= 28 | bignumeric |
decimal(48,s), 9 <= s <= 29 | bignumeric |
decimal(49,s), 10 <= s <= 30 | bignumeric |
decimal(5,s), 1 <= s <= 5 | numeric |
decimal(50,s), 11 <= s <= 31 | bignumeric |
decimal(51,s), 12 <= s <= 32 | bignumeric |
decimal(52,s), 13 <= s <= 33 | bignumeric |
decimal(53,s), 14 <= s <= 34 | bignumeric |
decimal(54,s), 15 <= s <= 35 | bignumeric |
decimal(55,s), 16 <= s <= 36 | bignumeric |
decimal(56,38) | bignumeric |
decimal(56,s), 17 <= s <= 37 | bignumeric |
decimal(6) | int64 |
decimal(6,s), 1 <= s <= 6 | numeric |
decimal(63,s), 24 <= s <= 38 | bignumeric |
decimal(7) | int64 |
decimal(7,s), 1 <= s <= 7 | numeric |
decimal(8) | int64 |
decimal(8,s), 1 <= s <= 8 | numeric |
decimal(9) | int64 |
decimal(p,39), 40 <= p <= 39 | string |
decimal(p,s), 10 <= p <= 38, 1 <= s <= 9 | numeric |
decimal(p,s), 11 <= p <= 38, 1 <= s <= 9 | numeric |
decimal(p,s), 12 <= p <= 38, 1 <= s <= 9 | numeric |
decimal(p,s), 13 <= p <= 38, 1 <= s <= 9 | numeric |
decimal(p,s), 14 <= p <= 38, 1 <= s <= 9 | numeric |
decimal(p,s), 15 <= p <= 38, 1 <= s <= 9 | numeric |
decimal(p,s), 16 <= p <= 38, 1 <= s <= 9 | numeric |
decimal(p,s), 17 <= p <= 38, 1 <= s <= 9 | numeric |
decimal(p,s), 18 <= p <= 38, 1 <= s <= 9 | numeric |
decimal(p,s), 19 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 20 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 21 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 22 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 23 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 24 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 25 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 26 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 27 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 28 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 29 <= p <= 30, 10 <= s <= 29 | bignumeric |
decimal(p,s), 29 <= p <= 38, 0 <= s <= 9 | numeric |
decimal(p,s), 30 <= p <= 38, 1 <= s <= 9 | numeric |
decimal(p,s), 30 <= p <= 49, 1 <= s <= 30 | bignumeric |
decimal(p,s), 31 <= p <= 38, 2 <= s <= 9 | numeric |
decimal(p,s), 31 <= p <= 50, 1 <= s <= 31 | bignumeric |
decimal(p,s), 32 <= p <= 38, 3 <= s <= 9 | numeric |
decimal(p,s), 32 <= p <= 51, 1 <= s <= 32 | bignumeric |
decimal(p,s), 33 <= p <= 38, 4 <= s <= 9 | numeric |
decimal(p,s), 33 <= p <= 52, 1 <= s <= 33 | bignumeric |
decimal(p,s), 34 <= p <= 38, 5 <= s <= 9 | numeric |
decimal(p,s), 34 <= p <= 53, 1 <= s <= 34 | bignumeric |
decimal(p,s), 35 <= p <= 38, 6 <= s <= 9 | numeric |
decimal(p,s), 35 <= p <= 54, 1 <= s <= 35 | bignumeric |
decimal(p,s), 36 <= p <= 38, 7 <= s <= 9 | numeric |
decimal(p,s), 36 <= p <= 55, 1 <= s <= 36 | bignumeric |
decimal(p,s), 37 <= p <= 38, 8 <= s <= 9 | numeric |
decimal(p,s), 37 <= p <= 56, 1 <= s <= 37 | bignumeric |
decimal(p,s), 38 <= p <= 56, 1 <= s <= 38 | bignumeric |
decimal(p,s), 39 <= p <= 56, 21 <= s <= 38 | bignumeric |
decimal(p,s), 40 <= p <= 41, 1 <= s <= 40 | string |
decimal(p,s), 41 <= p <= 42, 1 <= s <= 41 | string |
decimal(p,s), 41 <= p <= 56, 23 <= s <= 38 | bignumeric |
decimal(p,s), 42 <= p <= 43, 1 <= s <= 42 | string |
decimal(p,s), 42 <= p <= 56, 24 <= s <= 38 | bignumeric |
decimal(p,s), 43 <= p <= 44, 1 <= s <= 43 | string |
decimal(p,s), 43 <= p <= 56, 25 <= s <= 38 | bignumeric |
decimal(p,s), 44 <= p <= 56, 26 <= s <= 38 | bignumeric |
decimal(p,s), 44 <= p <= 63, 1 <= s <= 44 | string |
decimal(p,s), 45 <= p <= 56, 27 <= s <= 38 | bignumeric |
decimal(p,s), 45 <= p <= 63, 1 <= s <= 45 | string |
decimal(p,s), 46 <= p <= 56, 28 <= s <= 38 | bignumeric |
decimal(p,s), 46 <= p <= 63, 1 <= s <= 46 | string |
decimal(p,s), 47 <= p <= 56, 29 <= s <= 38 | bignumeric |
decimal(p,s), 47 <= p <= 63, 1 <= s <= 47 | string |
decimal(p,s), 48 <= p <= 56, 30 <= s <= 38 | bignumeric |
decimal(p,s), 48 <= p <= 63, 1 <= s <= 48 | string |
decimal(p,s), 49 <= p <= 56, 31 <= s <= 38 | bignumeric |
decimal(p,s), 49 <= p <= 63, 1 <= s <= 49 | string |
decimal(p,s), 50 <= p <= 56, 32 <= s <= 38 | bignumeric |
decimal(p,s), 50 <= p <= 63, 1 <= s <= 50 | string |
decimal(p,s), 51 <= p <= 56, 33 <= s <= 38 | bignumeric |
decimal(p,s), 51 <= p <= 63, 1 <= s <= 51 | string |
decimal(p,s), 52 <= p <= 56, 34 <= s <= 38 | bignumeric |
decimal(p,s), 52 <= p <= 63, 1 <= s <= 52 | string |
decimal(p,s), 53 <= p <= 56, 35 <= s <= 38 | bignumeric |
decimal(p,s), 53 <= p <= 63, 1 <= s <= 53 | string |
decimal(p,s), 54 <= p <= 56, 36 <= s <= 38 | bignumeric |
decimal(p,s), 54 <= p <= 63, 1 <= s <= 54 | string |
decimal(p,s), 55 <= p <= 56, 37 <= s <= 38 | bignumeric |
decimal(p,s), 55 <= p <= 63, 1 <= s <= 55 | string |
decimal(p,s), 56 <= p <= 63, 1 <= s <= 56 | string |
decimal(p,s), 56 <= p <= 63, 39 <= s <= 62 | string |
decimal(p,s), 57 <= p <= 63, 1 <= s <= 57 | string |
decimal(p,s), 57 <= p <= 63, 18 <= s <= 38 | bignumeric |
decimal(p,s), 58 <= p <= 63, 1 <= s <= 58 | string |
decimal(p,s), 58 <= p <= 63, 19 <= s <= 38 | bignumeric |
decimal(p,s), 59 <= p <= 63, 1 <= s <= 59 | string |
decimal(p,s), 59 <= p <= 63, 20 <= s <= 38 | bignumeric |
decimal(p,s), 60 <= p <= 63, 1 <= s <= 60 | string |
decimal(p,s), 60 <= p <= 63, 21 <= s <= 38 | bignumeric |
decimal(p,s), 61 <= p <= 63, 1 <= s <= 61 | string |
decimal(p,s), 61 <= p <= 63, 22 <= s <= 38 | bignumeric |
decimal(p,s), 62 <= p <= 63, 1 <= s <= 62 | string |
decimal(p,s), 62 <= p <= 63, 23 <= s <= 38 | bignumeric |
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 | int64 |
numeric(1) | int64 |
numeric(1,1) | numeric |
numeric(10) | int64 |
numeric(10,10) | bignumeric |
numeric(11) | int64 |
numeric(11,s), 10 <= s <= 11 | bignumeric |
numeric(12) | int64 |
numeric(12,s), 10 <= s <= 12 | bignumeric |
numeric(13) | int64 |
numeric(13,s), 10 <= s <= 13 | bignumeric |
numeric(14) | int64 |
numeric(14,s), 10 <= s <= 14 | bignumeric |
numeric(15) | int64 |
numeric(15,s), 10 <= s <= 15 | bignumeric |
numeric(16) | int64 |
numeric(16,s), 10 <= s <= 16 | bignumeric |
numeric(17) | int64 |
numeric(17,s), 10 <= s <= 17 | bignumeric |
numeric(18) | int64 |
numeric(18,s), 10 <= s <= 18 | bignumeric |
numeric(19,s), 10 <= s <= 19 | bignumeric |
numeric(2) | int64 |
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) | int64 |
numeric(3,s), 1 <= s <= 3 | numeric |
numeric(38,9) | numeric |
numeric(4) | int64 |
numeric(4,s), 1 <= s <= 4 | numeric |
numeric(40,s), 1 <= s <= 21 | bignumeric |
numeric(41,s), 2 <= s <= 22 | bignumeric |
numeric(42,s), 3 <= s <= 23 | bignumeric |
numeric(43,s), 4 <= s <= 24 | bignumeric |
numeric(44,s), 5 <= s <= 25 | bignumeric |
numeric(45,s), 6 <= s <= 26 | bignumeric |
numeric(46,s), 7 <= s <= 27 | bignumeric |
numeric(47,s), 8 <= s <= 28 | bignumeric |
numeric(48,s), 9 <= s <= 29 | bignumeric |
numeric(49,s), 10 <= s <= 30 | bignumeric |
numeric(5,s), 1 <= s <= 5 | numeric |
numeric(50,s), 11 <= s <= 31 | bignumeric |
numeric(51,s), 12 <= s <= 32 | bignumeric |
numeric(52,s), 13 <= s <= 33 | bignumeric |
numeric(53,s), 14 <= s <= 34 | bignumeric |
numeric(54,s), 15 <= s <= 35 | bignumeric |
numeric(55,s), 16 <= s <= 36 | bignumeric |
numeric(56,38) | bignumeric |
numeric(56,s), 17 <= s <= 37 | bignumeric |
numeric(6) | int64 |
numeric(6,s), 1 <= s <= 6 | numeric |
numeric(63,s), 24 <= s <= 38 | bignumeric |
numeric(7) | int64 |
numeric(7,s), 1 <= s <= 7 | numeric |
numeric(8) | int64 |
numeric(8,s), 1 <= s <= 8 | numeric |
numeric(9) | int64 |
numeric(p,39), 40 <= p <= 39 | string |
numeric(p,s), 10 <= p <= 38, 1 <= s <= 9 | numeric |
numeric(p,s), 11 <= p <= 38, 1 <= s <= 9 | numeric |
numeric(p,s), 12 <= p <= 38, 1 <= s <= 9 | numeric |
numeric(p,s), 13 <= p <= 38, 1 <= s <= 9 | numeric |
numeric(p,s), 14 <= p <= 38, 1 <= s <= 9 | numeric |
numeric(p,s), 15 <= p <= 38, 1 <= s <= 9 | numeric |
numeric(p,s), 16 <= p <= 38, 1 <= s <= 9 | numeric |
numeric(p,s), 17 <= p <= 38, 1 <= s <= 9 | numeric |
numeric(p,s), 18 <= p <= 38, 1 <= s <= 9 | numeric |
numeric(p,s), 19 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 20 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 21 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 22 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 23 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 24 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 25 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 26 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 27 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 28 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 29 <= p <= 30, 10 <= s <= 29 | bignumeric |
numeric(p,s), 29 <= p <= 38, 0 <= s <= 9 | numeric |
numeric(p,s), 30 <= p <= 38, 1 <= s <= 9 | numeric |
numeric(p,s), 30 <= p <= 49, 1 <= s <= 30 | bignumeric |
numeric(p,s), 31 <= p <= 38, 2 <= s <= 9 | numeric |
numeric(p,s), 31 <= p <= 50, 1 <= s <= 31 | bignumeric |
numeric(p,s), 32 <= p <= 38, 3 <= s <= 9 | numeric |
numeric(p,s), 32 <= p <= 51, 1 <= s <= 32 | bignumeric |
numeric(p,s), 33 <= p <= 38, 4 <= s <= 9 | numeric |
numeric(p,s), 33 <= p <= 52, 1 <= s <= 33 | bignumeric |
numeric(p,s), 34 <= p <= 38, 5 <= s <= 9 | numeric |
numeric(p,s), 34 <= p <= 53, 1 <= s <= 34 | bignumeric |
numeric(p,s), 35 <= p <= 38, 6 <= s <= 9 | numeric |
numeric(p,s), 35 <= p <= 54, 1 <= s <= 35 | bignumeric |
numeric(p,s), 36 <= p <= 38, 7 <= s <= 9 | numeric |
numeric(p,s), 36 <= p <= 55, 1 <= s <= 36 | bignumeric |
numeric(p,s), 37 <= p <= 38, 8 <= s <= 9 | numeric |
numeric(p,s), 37 <= p <= 56, 1 <= s <= 37 | bignumeric |
numeric(p,s), 38 <= p <= 56, 1 <= s <= 38 | bignumeric |
numeric(p,s), 39 <= p <= 56, 21 <= s <= 38 | bignumeric |
numeric(p,s), 40 <= p <= 41, 1 <= s <= 40 | string |
numeric(p,s), 41 <= p <= 42, 1 <= s <= 41 | string |
numeric(p,s), 41 <= p <= 56, 23 <= s <= 38 | bignumeric |
numeric(p,s), 42 <= p <= 43, 1 <= s <= 42 | string |
numeric(p,s), 42 <= p <= 56, 24 <= s <= 38 | bignumeric |
numeric(p,s), 43 <= p <= 44, 1 <= s <= 43 | string |
numeric(p,s), 43 <= p <= 56, 25 <= s <= 38 | bignumeric |
numeric(p,s), 44 <= p <= 56, 26 <= s <= 38 | bignumeric |
numeric(p,s), 44 <= p <= 63, 1 <= s <= 44 | string |
numeric(p,s), 45 <= p <= 56, 27 <= s <= 38 | bignumeric |
numeric(p,s), 45 <= p <= 63, 1 <= s <= 45 | string |
numeric(p,s), 46 <= p <= 56, 28 <= s <= 38 | bignumeric |
numeric(p,s), 46 <= p <= 63, 1 <= s <= 46 | string |
numeric(p,s), 47 <= p <= 56, 29 <= s <= 38 | bignumeric |
numeric(p,s), 47 <= p <= 63, 1 <= s <= 47 | string |
numeric(p,s), 48 <= p <= 56, 30 <= s <= 38 | bignumeric |
numeric(p,s), 48 <= p <= 63, 1 <= s <= 48 | string |
numeric(p,s), 49 <= p <= 56, 31 <= s <= 38 | bignumeric |
numeric(p,s), 49 <= p <= 63, 1 <= s <= 49 | string |
numeric(p,s), 50 <= p <= 56, 32 <= s <= 38 | bignumeric |
numeric(p,s), 50 <= p <= 63, 1 <= s <= 50 | string |
numeric(p,s), 51 <= p <= 56, 33 <= s <= 38 | bignumeric |
numeric(p,s), 51 <= p <= 63, 1 <= s <= 51 | string |
numeric(p,s), 52 <= p <= 56, 34 <= s <= 38 | bignumeric |
numeric(p,s), 52 <= p <= 63, 1 <= s <= 52 | string |
numeric(p,s), 53 <= p <= 56, 35 <= s <= 38 | bignumeric |
numeric(p,s), 53 <= p <= 63, 1 <= s <= 53 | string |
numeric(p,s), 54 <= p <= 56, 36 <= s <= 38 | bignumeric |
numeric(p,s), 54 <= p <= 63, 1 <= s <= 54 | string |
numeric(p,s), 55 <= p <= 56, 37 <= s <= 38 | bignumeric |
numeric(p,s), 55 <= p <= 63, 1 <= s <= 55 | string |
numeric(p,s), 56 <= p <= 63, 1 <= s <= 56 | string |
numeric(p,s), 56 <= p <= 63, 39 <= s <= 62 | string |
numeric(p,s), 57 <= p <= 63, 1 <= s <= 57 | string |
numeric(p,s), 57 <= p <= 63, 18 <= s <= 38 | bignumeric |
numeric(p,s), 58 <= p <= 63, 1 <= s <= 58 | string |
numeric(p,s), 58 <= p <= 63, 19 <= s <= 38 | bignumeric |
numeric(p,s), 59 <= p <= 63, 1 <= s <= 59 | string |
numeric(p,s), 59 <= p <= 63, 20 <= s <= 38 | bignumeric |
numeric(p,s), 60 <= p <= 63, 1 <= s <= 60 | string |
numeric(p,s), 60 <= p <= 63, 21 <= s <= 38 | bignumeric |
numeric(p,s), 61 <= p <= 63, 1 <= s <= 61 | string |
numeric(p,s), 61 <= p <= 63, 22 <= s <= 38 | bignumeric |
numeric(p,s), 62 <= p <= 63, 1 <= s <= 62 | string |
numeric(p,s), 62 <= p <= 63, 23 <= s <= 38 | bignumeric |
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 <= s <= 32740 | bytes |
varchar( size ) for bit data, 1 <= s <= 32740 | bytes |
varchar( size ), 1 <= s <= 32740 | string |
