Execute command

<< Driver command | Exit command >>

Derby Tools and Utilities Guide

ij> connect 'jdbc:derby:menuDB;create=true';
ij>

Elapsedtime command

Syntax

ELAPSEDTIME { ON | OFF }

Description

When

elapsedtime

is turned on,

displays the total time elapsed during statement

execution. The default value is OFF.

Example

ij> elapsedtime on;
ij> VALUES current_date;
1
----------
1998-07-15
ELAPSED TIME = 2134 milliseconds
ij>

Execute command

Syntax

EXECUTE { SQLString |

PreparedStatementIdentifier

}

[ USING {

String

Identifier

} ]

Description
Has several uses:

· To execute an SQL command entered as SQLString, using the Execute String style.

The String is passed to the connection without further examination or processing by

. Normally, you execute SQL commands directly, not with the Execute command.

· To execute a named command identified by PreparedStatementIdentifier. This must

be previously prepared with the

Prepare

command.

· To execute either flavor of command when that command contains dynamic

parameters, specify the values in the Using portion of the command. In this style,
the SQLString or previously prepared PreparedStatementIdentifier is executed
using the values supplied as String or Identifier. The Identifier in the USING clause
must have a result set as its result. Each row of the result set is applied to the
input parameters of the command to be executed, so the number of columns in
the Using's result set must match the number of input parameters in the Execute's
statement. The results of each execution of the Execute statement are displayed as
they are made. If the Using's result set contains no rows, the Execute's statement is
not executed.

When auto-commit mode is on, the Using's result set is closed upon the first
execution of the Execute statement. To ensure multiple-row execution of the
Execute command, use the

Autocommit

command to turn auto-commit off.

Examples

ij> autocommit off;
ij> prepare menuInsert as 'INSERT INTO menu VALUES (?, ?, ?)';
ij> execute menuInsert using 'VALUES
(''entree'', ''lamb chop'', 14),
(''dessert'', ''creme brulee'', 6)';
1 row inserted/updated/deleted
1 row inserted/updated/deleted