Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
DB2 for Linux, UNIX, and Windows Source Data Type | Google BigQuery Target Data Type |
|---|---|
bigint | int64 |
binary( size ), 1 <= s <= 255 | bytes |
boolean | bool |
char for bit data | bytes |
char( size ) for bit data, 2 <= s <= 255 | bytes |
character( size ), 1 <= s <= 255 | 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(31,s), 10 <= s <= 31 | bignumeric |
decimal(31,s), 2 <= s <= 9 | numeric |
decimal(4) | int64 |
decimal(4,s), 1 <= s <= 4 | numeric |
decimal(5,s), 1 <= s <= 5 | numeric |
decimal(6) | int64 |
decimal(6,s), 1 <= s <= 6 | numeric |
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,s), 10 <= p <= 31, 1 <= s <= 9 | numeric |
decimal(p,s), 11 <= p <= 31, 1 <= s <= 9 | numeric |
decimal(p,s), 12 <= p <= 31, 1 <= s <= 9 | numeric |
decimal(p,s), 13 <= p <= 31, 1 <= s <= 9 | numeric |
decimal(p,s), 14 <= p <= 31, 1 <= s <= 9 | numeric |
decimal(p,s), 15 <= p <= 31, 1 <= s <= 9 | numeric |
decimal(p,s), 16 <= p <= 31, 1 <= s <= 9 | numeric |
decimal(p,s), 17 <= p <= 31, 1 <= s <= 9 | numeric |
decimal(p,s), 18 <= p <= 31, 1 <= s <= 9 | numeric |
decimal(p,s), 19 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 20 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 21 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 22 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 23 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 24 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 25 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 26 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 27 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 28 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 29 <= p <= 30, 10 <= s <= 29 | bignumeric |
decimal(p,s), 29 <= p <= 31, 0 <= s <= 9 | numeric |
decimal(p,s), 30 <= p <= 31, 1 <= s <= 30 | bignumeric |
decimal(p,s), 30 <= p <= 31, 1 <= s <= 9 | numeric |
decimal(p,s), 9 <= p <= 31, 1 <= s <= 9 | numeric |
double | float64 |
integer | int64 |
long varchar | string |
long varchar for bit data | bytes |
real | float64 |
smallint | int64 |
time | time |
timestamp( precision ), 0 <= p <= 6 | datetime |
timestamp( precision ), 7 <= p <= 12 | string |
varbinary( size ), 1 <= s <= 32672 | bytes |
varchar( size ) for bit data, 1 <= s <= 32672 | bytes |
varchar( size ), 1 <= s <= 32672 | string |
