1.1

An input argument of type VARCHAR(128) that specifies the code set of the
data in the exported file. The name of the code set should be one of the
CODESET
Java-supported character encodings. Data is converted from the database code
set to the specified code set before writing to the file. Passing a NULL value
will write the data in the same code set as the node in which it is being executed.
If you create a schema or table name as a non-delimited identifier, you must pass the name to the export 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 export 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 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
583
SQL Language Reference