The following table contains the available data types for Oracle Rdb databases supported by CONNX.
|
CONNX Data Type |
SQL Data Type |
Length |
VMS Equivalent |
Description |
|
Binary |
BINARY |
1-30000 |
Maxcim RFA Maxcim Byte Array |
The binary field is not converted. It provides access to raw, unaltered data in an RMS file. |
|
Binary (Text) |
CHAR |
-1 |
|
|
|
Double |
DOUBLE |
8 |
Vms Double RealMaxcim Double Real |
Double precision floating point (8 bytes) |
|
Interval Date/Day/Second |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Date Hour |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Date Hour/Minute |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Date Hour/Second |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Date Minute |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Date Minute/Second |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Date Month |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Date Second |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Date Year |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Date Year/Month |
DOUBLE |
-1 |
|
|
|
Interval Day |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Hour |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Interval Minute |
DOUBLE |
-1 |
|
Rdb Interval data type |
|
Longword -> Decimal |
DECIMAL |
4 |
VMS Longword Integer with implied decimal PIC S9(X1)V9(X2) COMP where X1 + X2 is between 5 and 9. |
Longword Integer with an implied decimal place (4 bytes). |
|
Longword -> Double |
DOUBLE |
4 |
|
|
|
Longword |
INTEGER |
4 |
VMS Longword Integer PIC S9(X1) COMP where X1 is between 5 and 9. |
Longword Integer (4 bytes) |
|
Quadword -> Char |
VARCHAR |
8 |
|
|
|
Quadword -> Char(DP) |
VARCHAR |
8 |
|
|
|
Quadword -> Decimal |
DECIMAL |
8 |
VMS Quadword Integer with implied decimal PIC S9(X1)V9(X2) COMP where X1+X2 is between 10 and 20. |
Quadword Integer with an implied decimal place (8 bytes) converts to a SQL String. |
|
Rdb Date ANSI |
DATE |
16 |
|
|
|
Rdb Date VMS |
TIMESTAMP |
16 |
|
|
|
Rdb Date VMS (String) |
TIMESTAMP |
16 |
|
|
|
Rdb Time |
TIME |
16 |
|
|
|
Rdb Timestamp |
TIMESTAMP |
16 |
|
|
|
Signed Overpunch -> Double |
DOUBLE |
1 |
|
|
|
Single |
REAL |
16 |
|
|
|
String Tinyint |
TINYINT |
-1 |
|
|
|
String Smallint |
SMALLINT |
-1 |
|
|
|
String Integer |
INTEGER |
-1 |
|
|
|
String Quadword |
VARCHAR |
-1 |
|
|
|
String Single |
REAL |
-1 |
|
|
|
String Double |
DOUBLE |
-1 |
|
|
|
Text (Expandable) |
VARCHAR |
1-30000 |
|
Alphanumeric and symbols (1-30000 chars). |
|
Text (Null Terminated) |
VARCHAR |
-1 |
|
|
|
Text (Right Space Padded) |
CHAR |
1-30000 |
Text Maxcim Yes/No |
Alphanumeric and symbols. (1-30000 chars); same as Text but with right space padding. |
|
VMS Date/Time |
TIMESTAMP |
8 |
|
VMS Binary Date/Time (8 bytes) converts to an ODBC Timestamp. |
|
VMS G Float |
DOUBLE |
8 |
|
|
|
Word |
SMALLINT |
2 |
|
|