Data conversion for setting data from OLE DB Types to Db2 Types

The IBM® OLE DB Provider for Db2 supports data conversions for setting data from OLE DB types to Db2 types.

Supported data conversion from OLE DB Types to Db2 Types

The following table shows data conversions from OLE DB types to Db2 types. Note that truncation of the data may occur in some cases, depending on the types and the value of the data.

Table 1. Data conversions from OLE DB types to Db2 types
OLE DB Type Indicator
 Db2 Data Types
S
M
A
L
L
I
N
T
I
N
T
E
G
E
R
B
I
G
I
N
T
R
E
A
L
F
L
O
A
T

D
O
U
B
L
E
D
E
C
I
M
A
L

N
U
M
E
R
I
C
D
A
T
E
T
I
M
E
T
I
M
E
S
T
A
M
P
C
H
A
R
V
A
R
C
H
A
R
L
O
N
G

V
A
R
C
H
A
R
C
L
O
B
G
R
A
P
H
I
C
V
A
R
G
R
A
P
H
I
C
L
O
N
G

V
A
R
G
R
A
P
H
I
C
D
B
C
L
O
B
 For Bit Data
B
L
O
B
D
A
T
A

L
I
N
K
C
H
A
R
V
A
R
C
H
A
R
L
O
N
G

V
A
R
C
H
A
R
DBTYPE_EMPTY
DBTYPE_NULL
DBTYPE_RESERVED
DBTYPE_I1
X
X
X
X
X
X
X
X
DBTYPE_I2
X
X
X
X
X
X
X
X
DBTYPE_I4
X
X
X
X
X
X
X
X
DBTYPE_I8
X
X
X
X
X
X
X
X
DBTYPE_UI1
X
X
X
X
X
X
X
X
DBTYPE_UI2
X
X
X
X
X
X
X
X
DBTYPE_UI4
X
X
X
X
X
X
X
X
DBTYPE_UI8
X
X
X
X
X
X
X
X
DBTYPE_R4
X
X
X
X
X
X
X
X
DBTYPE_R8
X
X
X
X
X
X
X
X
DBTYPE_CY
DBTYPE_DECIMAL
X
X
X
X
X
X
X
X
DBTYPE_NUMERIC
X
X
X
X
X
X
X
X
DBTYPE_DATE
DBTYPE_BOOL
X
X
X
X
X
X
X
X
DBTYPE_BYTES
X
X
X
X
X
X
X
X
X
DBTYPE_BSTR
  - to be determined
DBTYPE_STR
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_WSTR
X
X
X
DBTYPE_VARIANT
  - to be determined
DBTYPE_IDISPATCH
DBTYPE_IUNKNOWN
X
X
X
 X
X
X
X
 X X X
X
DBTYPE_GUID
DBTYPE_ERROR
DBTYPE_BYREF
DBTYPE_ARRAY
DBTYPE_VECTOR
DBTYPE_UDT
DBTYPE_DBDATE
X
X
X
X
DBTYPE_DBTIME
X
X
X
X
DBTYPE_DBTIMESTAMP
X
X
X
X
X
DBTYPE_FILETIME
DBTYPE_PROP_VARIANT
DBTYPE_HCHAPTER
DBTYPE_VARNUMERIC