Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## SQLIStatement.execute

> Executes the SQL statement. This method is common to the `SQLIStatement` and `SQLPStatement` classes.

> ##### Format

> `public void execute()`

> ##### Returns

> None

> ##### Parameters

> None

> ##### Throws

> `DhSQLException`

> Example

> This code fragment illustrates the `setParam` and execute methods:

>     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

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095