If an SQL statement does not generate a result set, stored procedures can execute the statement in one of two ways:

• Immediate execution — Using methods of the SQLIStatement class, the procedure executes a statement once.
• Prepared execution — Using methods of the SQLPStatement class, the procedure prepares a statement for multiple executions in a procedure loop.