Bulk import and export

You can use import and export procedures which are executable from ij or any Java program. You must have derbytools.jar in your class path to use the import or export procedures.

To invoke an import or export procedure, you must be connected to the database into which data is imported or from which data is exported. Because the procedures will issue a COMMIT or a ROLLBACK statement, you should perform either a COMMIT or ROLLBACK to complete all transactions and release all table-level locks prior to invoking the import or export procedure. Other user applications that access the table with a separate connection do not need to disconnect.

Note:

Imports are transactional. If an error occurs during bulk import, all changes are rolled back.

This topic contains the following sections:

• Bulk-Import
• Bulk-Export
• Examples of bulk import and export
• Importing into tables with identity columns
• Executing import/export procedures from JDBC
• File format for input and output
• Treatment of NULLS
• CODESET values for import/export