SQLIStatement

Description

Methods of the SQLIStatement class provide for immediate (one-time) execution of c-treeACE SQL statements that do not generate a result set.

Note: SQLIStatement can be used to call stored procedures that do not have result sets.

Constructors

SQLIStatement (String statement)

Parameters

statement

A c-treeACE SQL statement that does not generate a result set. Enclose the statement in double quotes.

Throws

DhSQLException

Example

CREATE PROCEDURE insert_customer (

   IN  cust_number INTEGER,

   IN  cust_name   CHAR(20)

)

BEGIN

    SQLIStatement insert_cust = new SQLIStatement

           ("INSERT INTO customer VALUES (?,?) ");

    insert_cust.execute();

END

Note: The input parameter cust_name in the procedure above should be of type CHAR in ANSI versions of c-treeACE SQL.