1.1.1

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
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 results in an error.
FILENAME
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. Passing a
NULL value will use the default value; the default value is a comma (,).
COLUMNDELIMITER
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 uses the default value; the default value
is a double quotation mark (").
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 Java-supported
CODESET
character encodings. Data is converted from the specified code set to the database
code set (utf-8). Passing a NULL value interprets the data file in the same code
set as the node 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.
Input argument of type SMALLINT. With a non-zero value, this procedure
operates similarly to SYSCS_UTIL.IMPORT_TABLE, and it locks the table
LOCKTABLE
during the import operation. Specify a value of zero to prevent SQLFire from
locking the table during the import operation.
Specifies the number of threads to use for the import process. Each thread
processes a different portion of the file in parallel, and performs a bulk insert to
the SQLFire system.
NUMTHREADS
Input argument of type SMALLINT. With a non-zero value, SQLFire treats the
SCHEMANAME and TABLENAME arguments as case-sensitive. With a zero
value, SQLFire treats the schema and table names as case insensitive.
CASESENSITIVENAMES
The argument can specify a custom class that extends
com.vmware.sqlfire.load.Import. The specified class overrides the default import
IMPORTCLASSNAME
process, and can perform on-the-fly data conversions from external formats to
formats that SQLFire supports. If you specify NULL for this argument, then
SQLFire uses the default Import class. See Example with Custom Import
Class on page 606.
This argument is reserved for future use. Always specify NULL for the argument
in this release
ERRORFILE
Usage
For additional information on using this procedure see the section Using the bulk import and export procedures
in the Apache Derby documentation .
605
SQL Language Reference