CONNX Data Type | SQL Data Type | Length | VMS Equivalent Data Type | Description |
Big Double Text | CHAR | 48 | Oracle Large Number (38) | |
Binary (Text) | CHAR | 1-30000 | Maxcim RFA Maxcim Byte Array | The binary field is not converted. It provides access to raw, unaltered data in an RMS file. |
BLOB | LONG VARBINARY | 0-2147483000 | Binary Large Object | |
CLOB | LONG VARCHAR | 0-2147483000 | Character Large Object | |
Oracle Date | TIMESTAMP | 16 | Oracle Date | |
Oracle MLSLABEL | BINARY | 1-19 | Oracle MLSLABEL | |
Oracle Rowid | BINARY | 16 | Oracle Rowid | |
Oracle Timestamp | TIMESTAMP | -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. |
Text Space Padded (no nulls) | CHAR | -1 | ||
Varbinary | VARBINARY | -1 |