Can we for a specific session or transaction block set automatic commit(side effect) to off? Or is there a "ddl in tran" equivalent in ASA.
asked 15 Jan '13, 07:30
What are you trying to achieve?
As documented here, most SQL Anywhere DDL statements do an automatic commit as side effect, so they close a transaction by design.
When you are trying to execute DDL from within a stored procedure, there are certainly alternatives to do so. Say, if you need to create several objects in one transaction, have a look at the CREATE SCHEMA statement which allows to group several DDL statements in one transaction (or at least it rollbacks all statements when one statement fails, so I assume it just uses one single transaction...).
answered 15 Jan '13, 08:26