COLUMNDELIMITER
argument that is a VARCHAR (32672) data type.
signify the end of a column. You can specify a NULL value to use the default value of
a comma. The COLUMNDELIMITER parameter must be a CHAR (1) data type.
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.
of the Java-supported character encoding sets. Data is converted from the database
code page to the specified code page before writing to the file. You can specify a
NULL value to write the data in the same code page as the JVM in which it is being
executed. The CODESET parameter takes an input argument that is a VARCHAR
(128) data type.
the lob file is created in the same directory as the main export file. If you specify
the name of an existing file, the export utility overwrites the contents of the file.
The data is not appended to the file. If you are using the Network Server, the file
should be in a server-side location. Specifying a NULL value results in an error. The
LOBSFILENAME parameter takes an input argument that is a VARCHAR (32672)
data type.
pass the name to the export procedure using all uppercase characters. If you created a
schema or table 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.
"Setting the SQL standard authorization mode" in the Derby Developer's Guide for more
information. The database owner can grant access to other users. The user must also
have SELECT privileges on the table.
exporting data" in the Derby Server and Administration Guide.
data
database to the main file
'APP', 'STAFF', 'c:\data\staff.del', ',' ,'"',
'UTF-8', 'c:\data\pictures.dat');