IBM
C9530-001 · Question #35
In a Compute Node the Transaction mode is set to automatic and the "Throw exception on database error" is unchecked. How can the develop check on specific SQL codes and control the Commit or…
The correct answer is C. Check the SQLCODE and conditionally THROW an exception for handling Rollback or return true. See the full explanation below for the reasoning.
Question
In a Compute Node the Transaction mode is set to automatic and the "Throw exception on database error" is unchecked. How can the develop check on specific SQL codes and control the Commit or Rollback of the transaction from the ESQL Compute module?
Options
- ACheck the SQLCODE and conditionally return false for handling Rollback or return true for further
- B"Throw exception on database error" should never be unchecked when the Transaction mode is
- CCheck the SQLCODE and conditionally THROW an exception for handling Rollback or return true
- DCheck the SQLCODE and conditionally run the ESQL function ROLLBACK or COMMIT for
How the community answered
(21 responses)- A5% (1)
- B5% (1)
- C76% (16)
- D14% (3)
Community Discussion
No community discussion yet for this question.