1.0

JDBC Example
CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.EMPTY_STATEMENT_CACHE()");
cs.execute();
cs.close();
SQL Example
CALL SYSCS_UTIL.EMPTY_STATEMENT_CACHE();
SYSCS_UTIL.EXPORT_QUERY
Export the results of a SELECT statement to an operating system file.
For security concerns, and to avoid accidental file damage, this EXPORT procedure does not export data into
an existing file. You must specify a filename in the EXPORT procedure that does not exist. When you run the
procedure the file is created and the data is exported into the new file.
The data is exported using a delimited file format. For example, you can use this command to export the results
of a query as comma-separated values (a CSV file).
Syntax
SYSCS_UTIL.EXPORT_QUERY(IN SELECTSTATEMENT VARCHAR(32672),
IN FILENAME VARCHAR(32672), IN COLUMNDELIMITER CHAR(1),
IN CHARACTERDELIMITER CHAR(1), IN CODESET VARCHAR(128))
No result is returned from the procedure.
An input argument of type VARCHAR(32672) that specifies the select statement
(query) that will return the data to be exported. Passing a NULL value will result
in an error.
SELECTSTATEMENT
Specifies the name of a new file to which the data is to be exported. If the path
is omitted, the current working directory is used. If the name of a file that already
FILENAME
exists is specified, the export procedure returns an error. 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.
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 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.
Usage
For additional information on using this procedure see the section Using the bulk import and export procedures
in the Apache Derby documentation .
551
SQL Language Reference