The following chart shows how CA IDMS data types map to ODBC data types:
|
CA IDMS Data Type |
ODBC Data Type |
|---|---|
|
BINARY |
SQL_BINARY |
|
CHAR |
SQL_CHAR |
|
CHARACTER VARYING (VARCHAR synonym) |
SQL_VARCHAR |
|
DATE |
SQL_TYPE_DATE |
|
DECIMAL |
SQL_DECIMAL |
|
DOUBLE PRECISION* |
SQL_DOUBLE |
|
FLOAT* |
SQL_FLOAT |
|
GRAPHIC (DBCS Disabled) |
SQL_BINARY |
|
GRAPHIC (DBCS Enabled) |
CAID_GRAPHIC |
|
INTEGER |
SQL_INTEGER |
|
LONGINT |
SQL_BIGINT |
|
NUMERIC |
SQL_NUMERIC |
|
REAL* |
SQL_REAL |
|
SMALLINT |
SQL_SMALLINT |
|
TIME |
SQL_TYPE_TIME |
|
TIMESTAMP |
SQL_TYPE_TIMESTAMP |
|
UNSIGNED DECIMAL |
SQL_DECIMAL |
|
UNSIGNED NUMERIC |
SQL_NUMERIC |
|
VARCHAR |
SQL_VARCHAR |
|
VARGRAPHIC (DBCS Enabled) |
CAID_VARGRAPHIC |
|
VARGRAPHIC (DBCS Disabled) |
SQL_BINARY |
Note: * Floating point conversion subject to rounding errors due to format differences.
|
Copyright © 2009 CA.
All rights reserved.
|
|