IBM Exam C9530-001 Topic 8 Question 11 Discussion

Actual exam question for IBM's C9530-001 exam

Question #: 11
Topic #: 8

In a Compute Node the Transaction mode is set to automatic and the "Throw exception on database error" is unchecked. How can the developer check on specific SQL codes and control the Commit or Rollback of the transaction from the ESQL Compute module?

ACheck the SQLCODE and conditionally return false for handling Rollback or return true for further processing.

B'Throw exception on database error' should never be unchecked when the Transaction mode is set to automatic.

CCheck the SQLCODE and conditionally THROW an exception for handling Rollback or return true for further processing.

DCheck the SQLCODE and conditionally run the ESQL function ROLLBACK or COMMIT for handling Rollback or Commit respectively.

Show Suggested Answer

Suggested Answer: C

by Wilda at May 05, 2022, 11:14 PM

Limited Time Offer

25%

Off

Get Premium C9530-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!