1)    What is ttsabort statement?

To explicitly discard all changes in the current transaction, use the ttsabort

command. This results in the database being rolled back to the initial state.

Throwing an exception should be preferred to ttsabort.