Appendix B: Converting Datatypes
DB2 UDB / ODBC-supported
datatypes
The following table identifies the supported DB2 datatypes
and their related ODBC datatypes.
Table B-4: Supported
DB2 datatypes and related ODBC datatypes
DB2 datatypes
|
ODBC datatypes
|
CHAR
|
SQL_CHAR(1)
|
CHAR () (for bit data)
|
SQL_BINARY(-2)
|
DATE
|
SQL_TYPE_DATE(91)
|
DECIMAL
|
SQL_DECIMAL(3)
|
DOUBLE
|
SQL_DOUBLE(8)
|
FLOAT
|
SQL_FLOAT(6)
|
FLOAT (4)
|
SQL_REAL(7)
|
INTEGER
|
SQL_INTEGER(4)
|
* CLOB
|
SQL_LONGVARCHAR(-1)
|
LONG VARCHAR
|
SQL_LONGVARCHAR(-1)
|
* BLOB
|
SQL_LONGVARBINARY(-4)
|
LONG VARCHAR () (for bit data)
|
SQL_LONGVARBINARY(-4)
|
NUMERIC
|
SQL_NUMERIC(2)
|
SMALLINT
|
SQL_SMALLINT(5)
|
TIME
|
SQL_TYPE_TIME(92)
|
TIMESTAMP
|
SQL_TYPE_TIMESTAMP(93)
|
VARCHAR
|
SQL_VARCHAR(12)
|
VARCHAR () (for bit data)
|
SQL_VARBINARY(-3)
|
* Results sets containing these datatypes are truncated
to 32,768 bytes.
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF