The following chart shows how JDBC data types map to CA IDMS types when a parameter value is set.
|
JDBC Data Type |
CA IDMS Data Type |
|---|---|
|
BIT |
SMALLINT |
|
TINYINT |
SMALLINT |
|
SMALLINT |
SMALLINT |
|
INTEGER |
INTEGER |
|
BIGINT |
LONGINT |
|
REAL |
REAL |
|
FLOAT |
DOUBLE PRECISION |
|
DOUBLE |
DOUBLE PRECISION |
|
DECIMAL |
DECIMAL |
|
NUMERIC |
NUMERIC |
|
CHAR |
CHAR |
|
VARCHAR |
VARCHAR |
|
LONGVARCHAR |
VARCHAR |
|
BINARY |
BINARY |
|
VARBINARY |
BINARY |
|
LONGVARBINARY |
BINARY |
|
DATE |
DATE |
|
TIME |
TIME |
|
TIMESTAMP |
TIMESTAMP |
|
Copyright © 2009 CA.
All rights reserved.
|
|