The following limitations apply when the ODBC Operator runs on z/OS, UNIX, and Windows platforms.
- Whether the TruncateData flag is ON or OFF, the ODBC operator will truncate the Oracle Date to Vantage Date if the target column is mapped to INTDATE or ANSIDATE. If you don’t want to truncate the Oracle Date then you must map the target column to TIMESTAMP or CHAR(19).
- Normal “DATE” fields in Oracle cannot copy correctly over to Vantage's DATE field (in ANSI mode).
- On some non-database systems, the DATE column type does not equate to Vantage's ANSI Date field.
For example, on Oracle, the column type DATE is equivalent to the column type DATETIME, which has a format of YYYY-MM-DD HH:MM:SS (equivalent to a CHAR(19)). Vantage ANSI DATE has a format of YYYY-MM-DD (equivalent to CHAR(10)).