# Bulk-Import

Derby provides two import procedures you can use to perform bulk-import operations:

1. To import data from a file to a table, use the SYSCS_UTIL.SYSCS_IMPORT_TABLE procedure. The procedure definition is:

       SYSCS_UTIL.SYSCS_IMPORT_TABLE (IN schemaName VARCHAR(128),
       IN tableName VARCHAR(128), IN fileName VARCHAR(32672),
       IN columnDelimiter CHAR(1), IN characterDelimiter  CHAR(1),
       IN codeset VARCHAR(128), IN replace SMALLINT)

   No Result is returned from the procedure.
2. To import data from a file to a subset of columns in a table, use the SYSCS_UTIL.SYSCS_IMPORT_DATA procedure. To import data to subset of columns in a table, you specify insertColumns on the table into which data will be imported and/or specify columnIndexes to import data fields from a file to columns in a table. The procedure definition is:

       SYSCS_UTIL.SYSCS_IMPORT_DATA (IN schemaName VARCHAR(128),
       IN tableName VARCHAR(128), IN insertColumns VARCHAR(32672),
       IN columnIndexes VARCHAR(32672), IN fileName VARCHAR(32672),
       IN columnDelimiter CHAR(1), IN characterDelimiter  CHAR(1),
       IN codeset VARCHAR(128), IN replace SMALLINT)

   No result is returned from the procedure.

- Arguments to the import procedure

Parent topic: Bulk import and export
Related concepts
Importing into tables with identity columns
Executing import/export procedures from JDBC
File format for input and output
Treatment of NULLS
Related reference
Bulk-Export
Examples of bulk import and export
CODESET values for import/export