Data Type Mapping for Db2 for i
This section lists the mapping of data types for Db2 for i.
Db2 for i as Source
When Db2 for i is used as a source location, following is the mapping of data types in Db2 for i to the corresponding HVR repository data type.
Db2 for i | HVR Capture Support | HVR Repository Data Type |
---|---|---|
bigint | Native | bigint |
decfloat | Native | decfloat |
decimal | Native | decimal |
double | Native | double |
integer | Native | integer |
numeric | Native | numeric (db2i) |
real | Native | real |
smallint | Native | smallint |
date | Native | ansidate |
time | Native | time2 |
timestamp | Native | timestamp |
char | Native | char |
clob | Native | clob |
varchar | Native | varchar |
binary | Native | binary |
blob | Native | blob |
varbinary | Native | varbinary |
datalink | Extended | <<datalink>> |
xml | Extended | <<xml>> |
rowid | Extended | <<rowid>> |
dbclob | Native | clob |
graphic | Native | nchar |
vargraphic | Native | nvarchar |
user defined | Extended | <<user defined>> |
Db2 for i as Target
When Db2 for i is used as a target location, following is the mapping of HVR repository data types to the corresponding data type in Db2 for i.
Text in green cell indicates the native data type of the DBMS
HVR Repository Data Types | Attributes | Db2 for i |
---|---|---|
ansidate (ingres) | null=1 | date |
ansidate | null=1 | date |
bfile | null=1 | blob(2147483647) |
bigint unsigned |
bytelen=8
null=1 | decimal(20) |
bigint |
bytelen=8
null=1 | bigint |
binary |
bytelen=10
null=1 | binary(10) |
binary_double |
bytelen=8
null=1 | double |
binary_float |
bytelen=4
null=1 | real |
bit (mysql) |
bitlen=32
null=1 | varchar(32) |
bit |
bytelen=1
null=1 | smallint |
blob | null=1 | blob(2147483647) |
bool |
bytelen=1
null=1 | smallint |
boolean |
bytelen=1
null=1 | smallint |
byte varying |
bytelen=10
null=1 | varbinary(10) |
byte |
bytelen=10
null=1 | binary(10) |
byteint |
bytelen=1
null=1 | smallint |
c |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
char |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
char |
bytelen=4000
encoding=UTF-8 null=1 | char(4000) |
char |
bytelen=8000
encoding=UTF-8 null=1 | char(8000) |
char |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) |
char |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) |
char (oracle) |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
char (oracle) |
bytelen=2000
encoding=UTF-8 null=1 | char(2000) |
char (oracle) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) |
char (oracle) |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) |
clob |
encoding=UTF-8
null=1 | clob(2147483647) |
date | null=1 | timestamp |
date (hana) | null=1 | date |
date (mysql) | null=1 | date |
date (sybase) | null=1 | date |
datetime (bigquery) |
prec_sec=0
null=1 | timestamp |
datetime (mysql) |
prec_sec=0
null=1 | timestamp |
datetime (sybase) | null=1 | timestamp |
datetime | null=1 | timestamp |
datetime2 |
prec_sec=0
null=1 | timestamp |
datetimeoffset |
prec_sec=0
null=1 | timestamp |
db2 timestamp with time zone |
prec_sec=0
null=1 | timestamp |
db2 xml |
encoding=UTF-8
null=1 | clob(2147483647) |
dbclob |
charlen=0
null=1 | dbclob(1073741823) CCSID 13488 |
decfloat |
prec=16
null=1 | decfloat(16) |
decfloat |
prec=34
null=1 | decfloat(34) |
decimal |
prec=10
scale=3 null=1 | decimal(10,3) |
decimal |
prec=6
null=1 | decimal(6) |
double |
bytelen=8
null=1 | double |
epoch |
prec_sec=0
null=1 | timestamp |
float |
bytelen=8
null=1 | double |
float4 |
bytelen=4
null=1 | real |
float8 |
bytelen=8
null=1 | double |
float64 |
bytelen=8
null=1 | double |
graphic |
charlen=10
null=1 | nchar(10) |
image | null=1 | blob(2147483647) |
image (sybase) | null=1 | blob(2147483647) |
ingresdate | null=1 | timestamp |
int unsigned |
bytelen=4
null=1 | bigint |
int |
bytelen=4
null=1 | integer |
integer |
bytelen=4
null=1 | integer |
integer1 |
bytelen=1
null=1 | smallint |
integer2 |
bytelen=2
null=1 | smallint |
integer4 |
bytelen=4
null=1 | integer |
integer8 |
bytelen=8
null=1 | bigint |
int64 |
bytelen=8
null=1 | bigint |
interval day to second (ingres) |
prec_sec=0
null=1 | timestamp |
interval day to second |
prec_sec=0
prec_day=0 null=1 | timestamp |
interval month to second |
prec_sec=0
null=1 | timestamp |
interval year to month (ingres) | null=1 | timestamp |
interval year to month |
prec_year=0
null=1 | timestamp |
json | null=1 | clob(2147483647) |
jsonb | null=1 | clob(2147483647) |
long byte | null=1 | blob(2147483647) |
long char |
encoding=UTF-8
null=1 | clob(2147483647) |
long nvarchar (db2) |
charlen=0
null=1 | dbclob(1073741823) CCSID 13488 |
long nvarchar |
charlen=0
null=1 | dbclob(1073741823) CCSID 13488 |
long raw | null=1 | blob(2147483647) |
long varbinary | null=1 | blob(2147483647) |
long varchar (db2) |
encoding=UTF-8
null=1 | clob(2147483647) |
long varchar |
encoding=UTF-8
null=1 | clob(2147483647) |
long |
encoding=UTF-8
null=1 | clob(2147483647) |
mediumint unsigned |
bytelen=3
null=1 | integer |
mediumint |
bytelen=3
null=1 | integer |
money (ingres) | null=1 | decimal(14,2) |
money | null=1 | decimal(19,4) |
nchar |
charlen=10
null=1 | nchar(10) |
nchar (oracle) |
bytelen=20
charlen=10 null=1 | nchar(10) |
nclob |
charlen=0
null=1 | dbclob(1073741823) CCSID 13488 |
ntext |
charlen=0
null=1 | dbclob(1073741823) CCSID 13488 |
number |
scale=0
null=1 | decimal(63,4) |
number |
prec=10
scale=-127 null=1 | double |
number |
prec=10
scale=3 null=1 | decimal(10,3) |
number |
prec=26
scale=0 null=1 | decimal(26) |
number |
prec=6
scale=0 null=1 | integer |
numeric (db2i) |
prec=10
scale=3 null=1 | numeric(10,3) |
numeric (db2i) |
prec=6
null=1 | numeric(6) |
numeric |
prec=10
scale=3 null=1 | numeric(10,3) |
numeric |
prec=26
null=1 | numeric(26) |
numeric |
prec=6
null=1 | numeric(6) |
nvarchar |
charlen=10
null=1 | nvarchar(10) |
nvarchar(max) |
charlen=0
null=1 | dbclob(1073741823) CCSID 13488 |
nvarchar2 |
charlen=10
null=1 | nvarchar(10) |
postgres date | null=1 | date |
postgres timestamp with time zone |
prec_sec=0
null=1 | timestamp |
postgres timestamp |
prec_sec=0
null=1 | timestamp |
raw |
bytelen=10
null=1 | varbinary(10) |
real |
bytelen=4
null=1 | real |
rowid |
bytelen=18
charlen=18 encoding=US-ASCII null=1 | char(18) |
rowversion |
bytelen=10
null=1 | binary(10) |
smalldatetime | null=1 | timestamp |
smallint unsigned |
bytelen=2
null=1 | integer |
smallint |
bytelen=2
null=1 | smallint |
smallmoney | null=1 | decimal(10,4) |
text (ingres) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
text (sqlserver) |
encoding=WINDOWS-1252
null=1 | clob(2147483647) |
text(sybase) |
encoding=UTF-8
null=1 | clob(2147483647) |
time (mysql) |
prec_sec=0
null=1 | time |
time (hana) | null=1 | time |
time (sybase) | null=1 | time |
time with local time zone |
prec_sec=0
null=1 | time |
time with time zone |
prec_sec=0
null=1 | time |
time |
prec_sec=0
null=1 | time |
time |
prec_sec=3
null=1 | time |
time2 | null=1 | time |
timestamp (bigquery) |
prec_sec=0
null=1 | timestamp |
timestamp (db2) |
prec_sec=0
null=1 | timestamp |
timestamp (hana) |
prec_sec=0
null=1 | timestamp |
timestamp (ingres) |
prec_sec=0
null=1 | timestamp |
timestamp (mysql) |
prec_sec=0
null=1 | timestamp |
timestamp (oracle) |
prec_sec=0
null=1 | timestamp |
timestamp (sqlserver) |
bytelen=10
null=1 | binary(10) |
timestamp (sybase) |
bytelen=10
null=1 | varbinary(10) |
timestamp with local time zone |
prec_sec=0
null=1 | timestamp |
timestamp with local tz (oracle) |
prec_sec=0
null=1 | timestamp |
timestamp with time zone |
prec_sec=0
null=1 | timestamp |
timestamp with tz (oracle) |
prec_sec=0
null=1 | timestamp |
timestamp |
prec_sec=0
null=1 | timestamp |
tinyint signed |
bytelen=1
null=1 | smallint |
tinyint unsigned |
bytelen=1
null=1 | smallint |
tinyint |
bytelen=1
null=1 | smallint |
uniqueidentifier |
bytelen=16
null=1 | binary(16) |
unitext |
charlen=0
null=1 | dbclob(1073741823) CCSID 13488 |
univarchar |
charlen=10
null=1 | nvarchar(10) |
unsigned bigint |
bytelen=8
null=1 | decimal(20) |
unsigned int |
bytelen=4
null=1 | bigint |
unsigned smallint |
bytelen=2
null=1 | integer |
urowid |
bytelen=100
charlen=100 encoding=US-ASCII null=1 | varchar(100) |
varbinary |
bytelen=10
null=1 | varbinary(10) |
varbinary (sybase) |
bytelen=10
null=1 | varbinary(10) |
varbinary(max) | null=1 | blob(2147483647) |
varbyte |
bytelen=10
null=1 | varbinary(10) |
varchar |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
varchar |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
varchar |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
varchar |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
varchar (sybase) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
varchar (sybase) |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
varchar (sybase) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
varchar (sybase) |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
varchar(max) |
encoding=WINDOWS-1252
null=1 | clob(2147483647) |
varchar2 |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
varchar2 |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
varchar2 |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
vargraphic |
charlen=10
null=1 | nvarchar(10) |
xml |
charlen=0
null=1 | dbclob(1073741823) CCSID 13488 |
year (mysql) | null=1 | smallint |