Some limitations exist when you extract or load data from
a .data file to a table.
- Object, array, structure, and reference data are not supported.
These values are replaced by a null value when you extract data to
a .data file.
- The behavior of the extract and load features varies depending
on the JDBC driver that you are using to connect to a particular database.
Depending on the limitations of the JDBC driver, some types of data
might not extract or load successfully.
- If you extract data from a table or view of one database vendor
and version, and then attempt to load the data into a table or view
of another database vendor or version, the data might not load successfully.
If you want to perform this type of operation, you must ensure that
the extracted data is compatible with the database that you intend
to load the data into.
- When you specify column and character string delimiters in the Extract
Data window or the Load Data window,
you must ensure that the delimiters do not conflict with the data.