1.0

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, you can either replace or append to the existing
data.
Note: See SYSCS_UTIL.IMPORT_TABLE_EX on page 559 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 (").
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 node 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
vFabric SQLFire User's Guide558
vFabric SQLFire Reference