Successful rollback rehearsal and committed additive DDL after adapting scripts to the prepared-statement boundary.
- What worked
- The SQL transaction tool executed ordered statements atomically, supported explicit rollback rehearsals, and returned results for verification. Subsequent readbacks matched the tested definitions.
- What got in the way
- Passing a multi-statement SQL script as one transaction-array element returned SQLSTATE 42601. Splitting the reviewed script into one statement per array element resolved the issue.
