Executes a simple SQL statement (without result set).




Call the execute() method to execute the prepared SQL statement, without producing a result set (such as INSERT, UPDATE, DELETE or CREATE TABLE).

The SQL statement must have been prepared with a prepare() call.

If the SQL statement contains ? parameter place holders, issue a setParameter() call for each parameter, before executing the SQL statement.

As with standard Genero SQL instructions, SQL errors can be trapped with WHENEVER ERROR or TRY / CATCH blocks and by testing sqlca.sqlcode.


DEFINE sh base.SqlHandle
CALL sh.execute()

For a complete example, see Example 1: SqlHandle with simple SQL.