3.18 Definition SQL runtime considerations

1. When a definition SQL statement is executed, if it finishes normally, a COMMIT is automatically executed before the transaction terminates.

2. Definition SQL is not subject to rollback.

3. A definition SQL statement produces an error if both of the following conditions are met:

   • Within the connection in which the definition SQL statement is executed, there is a cursor performing retrieval from one of the following tables:

     • A dictionary table that is referenced or updated in the definition SQL statement

     • A table that is changed or deleted in the definition SQL statement

   • The above-mentioned cursor is open

4. A definition SQL statement produces an error if both of the following conditions are met:

   • The definition SQL statement is executed using the JDBC driver.

   • Within the same connection, there is a Statement object or a PreparedStatement object performing retrieval from one of the following tables:

     • A dictionary table that is referenced or updated in the definition SQL statement

     • A table that is changed or deleted in the definition SQL statement

5. If a definition SQL statement is executed using the JDBC driver, it produces an error if there is a ResultSet object within the same connection.

To Page Top