DB2 10.5 for Linux, UNIX, and Windows

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.
Related reference:
Data conversion for setting data from OLE DB Types to DB2 Types