1.1

•
length is the size of the LOB column data in bytes
For additional information on using this procedure see the section "Using the bulk import and export procedures"
in the Apache Derby Tools and Utilities Guide.
Example importing data into specific columns, using a separate import file for the LOB data
The following example shows how to import data into several columns of the STAFF table. The STAFF table
includes a LOB column in a sample database. The import file staff.del is a delimited data file. The
staff.del file contains references that point to a separate file which contains the LOB data. The data in the
import file is formatted using double quotation marks (") as the string delimiter and a comma (,) as the column
delimiter. The data will be appended to the existing data in the STAFF table. The import procedure uses the
default import implementation with 2 threads, and does not lock the target table:
CALL SYSCS_UTIL.IMPORT_DATA_LOBS_FROM_EXTFILE
(null, 'STAFF', 'NAME,DEPT,SALARY,PICTURE', '2,3,4,6',
'c:\data\staff.del', ',','"','UTF-8', 0, 0, 2, 0, null, null);
SYSCS_UTIL.IMPORT_TABLE
Import data from an input file into all of the columns of a table.
The SYSCS_UTIL.IMPORT_TABLE system procedure imports data from an input file into all of the columns
of a table. For example, you can use this procedure to import data from a comma-separated value (CSV) file or
other delimited file format.
If the table receiving the imported data already contains data, this command appends the new data without
affecting existing data. Use TRUNCATE TABLE if you want to clear existing table data before importing data.
Note: See SYSCS_UTIL.IMPORT_TABLE_EX on page 589 for an updated version of this procedure.
Syntax
SYSCS_UTIL.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.
An input argument of type VARCHAR(128) that specifies the schema of the
table. Passing a NULL value will use the default schema name.
SCHEMANAME
An input argument of type VARCHAR (128) that specifies the table name of
the table into which the data is to be imported. This table cannot be a system
table or a declared temporary table. Passing a null will result in an error.
TABLENAME
An input argument of type VARCHAR(32672) that specifies the file that contains
the data to be imported. If you do not specify a path, the current working directory
is used. Passing a NULL value will result in an error.
FILENAME
An input argument of type CHAR(1) that specifies a column delimiter. The
specified character is used in place of a comma to signal the end of a column.
COLUMNDELIMITER
Passing a NULL value will use the default value; the default value is a comma
(,).
An input argument of type CHAR(1) that specifies a character delimiter. The
specified character is used in place of double quotation marks to enclose a
CHARACTERDELIMITER
character string. Passing a NULL value will use the default value; the default
value is a double quotation mark (").
vFabric SQLFire User's Guide588
vFabric SQLFire Reference