I have a SQL query - command action block in my transaction used to insert data into a database. I'd like to capture the output of that query into an output variable even when the query fails, but I seem to be having some trouble. Currently, when the query fails (because the insert data is incorrect, or the database isn't available, or any other number of reasons) the transaction terminates and action blocks beyond the query do not get executed. Is there a way to prevent the transaction from terminating and allow me to define the next-step logic when the query fails?
I'm using MII 12.2.3 Build(177)