1.0

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 documentation .
Example
The following example imports data into the STAFF table from a delimited data file called myfile.del with
the percentage character (%) as the string delimiter, and a semicolon (;) as the column delimiter:
CALL SYSCS_UTIL.IMPORT_TABLE
(null, 'STAFF', 'c:/output/myfile.del', ';', '%', null, 0);
SYSCS_UTIL.IMPORT_TABLE_EX
Extended version of SYSCS_UTIL.IMPORT_TABLE that enables you to import data without locking the target
table. Use this procedure during long import operations when you require continued access to the table.
The SYSCS_UTIL.IMPORT_TABLE_EX system procedure imports data from an input file into all 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. This procedure enables you to control whether the table is locked during the import
operation, as well as whether SQLFire treats the schema and table names are case sensitive or case-insensitive.
If the table receiving the imported data already contains data, you can either replace or append to the existing
data.
Syntax
SYSCS_UTIL.IMPORT_TABLE_EX (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,
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(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 (").
559
SQL Language Reference