Overview

Derby provides import and export system procedures that you can use to import and export data in delimited data file format.

• Use export procedures to write data from a database to one or more files that are stored outside of the database. You can use an procedure to export data from a table into a file or export data from a SELECT statement result into a file.
• Use import procedures to import data from a files into a table. If the target table already contains data, you can replace or append to the existing data.

You can perform an Import or Export operation from ij or from within an SQL statement.

This topic contains the following sections:

• Options for running the import and export procedures
• Requirements and considerations