|
|
|
Description
Methods of the SQLIStatement class provide for immediate (one-time) execution of FairCom DB 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 FairCom DB 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 FairCom DB SQL.
