1.0

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. Imported data is always added
(inserted) to the target table without changing the existing table data. Specify
any value of type SMALLINT.
REPLACE
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
Input argument of type VARCHAR (32762) that specifies the column names
(separated by commas) of the table into which the data is to be imported. Passing
a NULL value imports the data into all columns of the table.
INSERTCOLUMNS
Input argument of type VARCHAR (32762) that specifies the indexes (numbered
from 1 and separated by commas) of the input data fields to be imported. Passing
a NULL value uses all input data fields in the file.
COLUMNINDEXES
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
vFabric SQLFire User's Guide554
vFabric SQLFire Reference