The following chart shows how CA IDMS types map to JDBC data types when data is returned in a result set:
|
CA IDMS Data Type |
JDBC Data Type |
|---|---|
|
SMALLINT |
SMALLINT |
|
INTEGER |
INTEGER |
|
LONGINT |
BIGINT |
|
REAL |
REAL |
|
FLOAT |
REAL (Precision < 25). |
|
FLOAT |
FLOAT (Precision > 24). |
|
DOUBLE PRECISION |
DOUBLE |
|
DECIMAL |
DECIMAL |
|
UNSIGNED DECIMAL |
DECIMAL |
|
NUMERIC |
NUMERIC |
|
UNSIGNED NUMERIC |
NUMERIC |
|
CHAR |
CHAR |
|
GRAPHIC |
CHAR (DBCS must be enabled) |
|
VARCHAR |
VARCHAR |
|
VARGRAPHIC |
VARCHAR (DBCS must be enabled) |
|
BINARY |
BINARY |
|
DATE |
DATE |
|
TIME |
TIME |
|
TIMESTAMP |
TIMESTAMP |
|
Copyright © 2009 CA.
All rights reserved.
|
|