1.0

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 shows how to export information from the STAFF table in a SAMPLE database to the
myfile.del file.
CALL SYSCS_UTIL.EXPORT_TABLE (null, 'STAFF', 'myfile.del', null, null,
null);
SYSCS_UTIL.IMPORT_DATA
The SYSCS_UTIL.IMPORT_DATA system procedure imports data to a subset of columns in a table. You
choose the subset of columns by specifying insert columns. This procedure is also used to import a subset of
column data from a file by specifying column indexes.
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)
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 (32762) that specifies the column names
(separated by commas) of the table into which the data is to be imported. Passing
a NULL value will import the data into all of the columns of the table.
INSERTCOLUMNS
An 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 will use all of the input data fields in the file.
COLUMNINDEXES
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
553
SQL Language Reference