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

For getting data, the IBM® OLE DB Provider allows data conversions from Db2 types to OLE DB types.

Supported data conversions from Db2 types to OLE DB types

The following table shows supported data conversions from Db2 types to OLE DB 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 Db2 types to OLE DB 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
X
X
X
X
X
X
X
DBTYPE_I2
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_I4
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_I8
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_UI1
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_UI2
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_UI4
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_UI8
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_R4
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_R8
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_CY
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_DECIMAL
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_NUMERIC
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_DATE
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_BOOL
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_BYTES
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_BSTR
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
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
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_VARIANT
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_IDISPATCH
DBTYPE_IUNKNOWN
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_GUID
X
X
X
X
X
X
X
X
X
X
DBTYPE_ERROR
DBTYPE_BYREF
DBTYPE_ARRAY
DBTYPE_VECTOR
DBTYPE_UDT
DBTYPE_DBDATE
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_DBTIME
X
X
X
X
X
X
X
X
X
X
DBTYPE_DBTIMESTAMP
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_FILETIME
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_PROP_VARIANT
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
DBTYPE_HCHAPTER
DBTYPE_VARNUMERIC
Note: When the application performs the ISequentialStream::Read to get the data from the storage object, the format of the data returned depends on the column data type:
  • For non character and binary data types, the data of the column is exposed as a sequence of bytes which represent those values in the operating system.
  • For character data type, the data is first converted to DBTYPE_STR.
  • For DBCLOB, the data is first converted to DBTYPE_WCHAR.