This section defines the SQL type mappings used by CA DataMinder to map CA DataMinder SQL Types to a DBMS specific datatype.
|
CA DataMinder Type |
MS SQL Type |
Oracle Type |
|
IDENTITYDEF |
Decimal(28,0)identity(1,1) |
NUMERIC |
|
IDENTITYREF |
Decimal(28,0)identity(1,1) |
NUMERIC |
|
INTEGER |
INT |
NUMBER(10) |
|
VARCHAR |
VARCHAR |
VARCHAR2 |
|
DECIMAL |
DECIMAL |
NUMBER |
|
TIMESTAMP |
DATETIME |
DATE |
|
BIT |
BIT |
NUMBER(1,0) |
|
VARBINARY |
VARBINARY |
RAW |
|
LONGVARCHAR |
TEXT |
VARCHAR2(4000) |
|
LONGVARBINARY |
IMAGE |
LONG RAW |
|
Copyright © 2012 CA.
All rights reserved.
|
|