Kbase P95157: Which are the DB2 data types supported by the ODBC DataServer in 10.0B?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/08/2009 |
|
Status: Unverified
GOAL:
List of supported DB2 data types for ODBC DataServer
GOAL:
Which are the DB2 data types supported by the ODBC DataServer in 10.0B?
FACT(s) (Environment):
OpenEdge 10x
Windows
ODBC DataServer
FIX:
DB2 DataType SQL-ODBC DataType OpenEdge default
integer SQL_INTEGER INTEGER (DECIMAL or LOGICAL)
smallint SQL_SMALLINT INTEGER (DECIMAL or LOGICAL)
decimal SQL_DECIMAL DECIMAL (INTEGER)
real/float SQL_REAL DECIMAL (INTEGER)
double precision//float SQL_FLOAT DECIMAL (INTEGER)
date SQL_TIMESTAMP CHARACTER (DATE)
time SQL_TIMESTAMP CHARACTER
timestamp SQL_TIMESTAMP CHARACTER/ (DATE)  .;
char(n) SQL_CHARACTER CHARACTER
varchar(n) SQL_VARCHAR CHARACTER
long varchar(n) SQL_LONGVARCHAR CHARACTER
graphic SQL_BINARY CHARACTER
vargraphic(n) SQL_VARBINARY CHARACTER
long vargraphic SQL_LONGBINARY CHARACTER
.