Problem:

INSERT/UPDATE/DELETE statements return SQLCODE of 0, though the changes have not been applied to the database.

Why are the INSERT/UPDATE/DELETE statements not working?

Resolution:

The default behavior will be to rollback. You should either code an explicit EXEC SQL COMMIT statement, or with OpenESQL applications, compile with the SQL(AUTOCOMMIT) compiler directive.