You can import and export large amounts of data between files and
the Derby database. Instead
of having to use INSERT and SELECT statements, you can use Derby system
procedures to import data directly from files into tables and to export data
from tables into files.
The Derby system procedures
import and export data in delimited data file format.
- Use the export system procedures to write data from a database to one
or more files that are stored outside of the database. You can use a procedure
to export data from a table into a file or export data from a SELECT statement
result into a file.
- Use the import system procedures to import data from a file into a table.
If the target table already contains data, you can replace or append to the
existing data.