Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

SQLIStatement.execute

Executes the FairCom DB SQL statement. This method is common to the SQLIStatement and SQLPStatement classes.

Format

public void execute()

Returns

None

Parameters

None

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.setParam (1, cust_number);

insert_cust.setParam (2, cust_name);

insert_cust.execute ();

END

TOCIndex