一括取り込みデータベース

前へ次へ

DB2 for iソースとGoogle BigQueryターゲット

次の表は、DB2 for iソースとGoogle BigQueryターゲットを使用した一括取り込みデータベース設定の推奨データ型マッピングを示しています。

DB2 for iソースデータ型	Google BigQueryターゲットデータ型
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