background image
<< Importing data using the built-in procedures | Import into tables with identity columns >>

Parameters for the import procedures

<< Importing data using the built-in procedures | Import into tables with identity columns >>
Derby Server and Administration Guide
71
Type of Import
Procedure to Use
must specify the COLUMNINDEXES parameter to
import data fields from a file to column in a table.
To import data to a
subset of columns
in a table, where the
LOB data is stored in
a separate file and the
main import file contains
all of the other data with
a reference to the LOB
data
SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE
(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)
The import utility looks in the main import file for a
reference to the location of the LOB data. The format
of the reference to the LOB stored in the main import
file must be
lobsFileName.Offset.length/
.
Parameters for the import procedures
The Derby import procedures use specific parameters.
SCHEMANAME
Specifies the schema of the table. You can specify a NULL value to use the default
schema name. The SCHEMANAME parameter takes an input argument that is a
VARCHAR(128) data type.
TABLENAME
Specifies the name of the table into which the data is to be imported. This table
cannot be a system table or a declared temporary table. The string must exactly
match the case of the table name. Specifying a NULL value results in an error. The
TABLENAME parameter takes an input argument that is a VARCHAR(128) data type.
INSERTCOLUMNS
Specifies the comma-separated column names of the table into which the data will be
imported. You can specify a NULL value to import into all columns of the table. The
INSERTCOLUMNS parameter takes an input argument that is a VARCHAR(32672)
data type.
COLUMNINDEXES
Specifies the comma-separated column indexes (numbered from one) of the input
data fields that will be imported. You can specify a NULL value to use all input data
fields in the file. The COLUMNINDEXES parameter takes an input argument that is a
VARCHAR(32672) data type.
FILENAME
Specifies the name of the file that contains the data to be imported. If the path is
omitted, the current working directory is used. The specified location of the file should
refer to the server side location if you are using the Network Server. Specifying a
NULL value results in an error. The FILENAME parameter takes an input argument
that is a VARCHAR(32672) data type.
COLUMNDELIMITER
Specifies a column delimiter. The specified character is used in place of a comma to
signify the end of a column. You can specify a NULL value to use the default value
of a comma. The COLUMNDELIMITER parameter takes an input argument that is a
CHAR(1) data type.
CHARACTERDELIMITER
Specifies a character delimiter. The specified character is used in place of double
quotation marks to enclose a character string. You can specify a NULL value to
use the default value of a double quotation mark. The CHARACTERDELIMITER
parameter takes an input argument that is a CHAR(1) data type.
CODESET