You can map DirectConnect for z/OS datatypes to standard ODBC datatypes using the lists in the following table.
DirectConnect for z/OS (DB2) |
ODBC |
---|---|
binary |
SQL_VARBINARY |
bit |
SQL_BIT |
char |
SQL_VARCHAR |
datetime |
SQL_TIMESTAMP |
decimal |
SQL_DECIMAL |
float |
SQL_FLOAT |
image |
SQL_LONGVARBINARY |
int |
SQL_INTEGER |
money |
SQL_DECIMAL |
numeric |
SQL_NUMERIC |
real |
SQL_REAL |
smalldatetime |
SQL_TIMESTAMP |
smallint |
SQL_SMALLINT |
smallmoney |
SQL_DECIMAL |
sysname |
SQL_VARCHAR |
text |
SQL_LONGVARCHAR |
timestamp |
SQL_VARBINARY |
varbinary |
SQL_VARBINARY |
varchar |
SQL_VARCHAR |
Copyright © 2005. Sybase Inc. All rights reserved. |