The DB2 access service performs datatype conversions for bulk copy transfer from statements. These conversions are defined within the DB2 access service and are not affected by the settings of the datatype conversion configuration properties and set statements.Each DB2 access service specification will include specific definitions of datatype mapping for that target DBMS. The DB2 access service converts these datatypes into the actual datatypes of the target columns. If the DB2 access service cannot convert the columns, the DB2 access service ends the transfer with an error.
The DB2 access service performs datatype conversions for bulk copy transfers. These conversions are defined within the DB2 access service and are not affected by the settings of the datatype conversions configuration properties. Each DB2 access service specification includes specific definitions of datatype mapping for that target DBMS.
Table 9-1 shows the acceptable Open Server datatypes that the DB2 access service can convert into corresponding DB2 datatypes. To save space in this table, the CS_ PREFIX is removed from Open Server datatypes, and similar DB2 datatypes are combined.
From Open Server datatypes (below) |
To DB2 datatypes (across) |
||||
|---|---|---|---|---|---|
CHAR VARCHAR |
INT SMALLINT |
DECIMAL FLOAT REAL |
DATE TIME TIMESTAMP |
CHAR FOR BIT DATA VARCHAR FOR BIT DATA |
|
CHAR |
X |
X |
X |
X |
X |
VARCHAR |
X |
X |
X |
X |
|
TEXT |
X |
X |
X |
X |
X |
BINARY |
X |
X |
|||
VARBINARY |
X |
X |
|||
IMAGE |
X |
X |
|||
BIT |
X |
X |
X |
||
SMALLINT |
X |
X |
X |
||
INTEGER |
X |
X |
X |
||
DECIMAL |
X |
X |
X |
||
MONEY |
X |
X |
X |
||
MONEY4 |
X |
X |
X |
||
REAL |
X |
X |
X |
||
FLOAT |
X |
X |
X |
||
DATETIME |
X |
X |
|||
DATETIME4 |
X |
X |
|||
