1.1

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 (").
An input argument of type VARCHAR(128) that specifies the code set of the
data in the input file. The name of the code set should be one of the
CODESET
Java-supported character encodings. Data is converted from the specified code
set to the database code set (utf-8). Passing a NULL value will interpret the data
file in the same code set as the JVM in which it is being executed.
SQLFire does not implement this argument; specify any value of type
SMALLINT. Imported data is always added (inserted) to the target table without
REPLACE
changing the existing table data. Use TRUNCATE TABLE if you want to clear
existing table data before importing data.
If you create a schema, table, or column name as a non-delimited identifier, you must pass the name to the import
procedure using all uppercase characters. If you created a schema, table, or column name as a delimited identifier,
you must pass the name to the import procedure using the same case that was used when it was created.
Usage
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
The following example imports some of the data fields from a delimited data file called data.del into the
STAFF table:
CALL SYSCS_UTIL.IMPORT_DATA
(NULL, 'STAFF', null, '1,3,4', 'data.del', null, null, null,0)
SYSCS_UTIL.IMPORT_DATA_EX
An extended version of SYSCS_UTIL.IMPORT_DATA that enables you to import data into specific columns
without locking the target table. Use this procedure during long import operations when you require continued
access to the table.
Syntax
SYSCS_UTIL.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,
IN LOCKTABLE SMALLINT, IN NUMTHREADS INTEGER, IN CASESENSITIVENAMES SMALLINT,
IN IMPORTCLASSNAME VARCHAR(32672), IN ERRORFILE VARCHAR(32672))
No result is returned from the procedure.
Input argument of type VARCHAR(128) that specifies the schema of the table.
Passing a NULL value uses the default schema name.
SCHEMANAME
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 results in an error.
TABLENAME
vFabric SQLFire User's Guide584
vFabric SQLFire Reference