AUTOCOMMIT is an option that can be set in a SET TRANSACTION statement.
Trafodion SQL provides concurrent database access for most operations and controls database access through concurrency control and the mechanism for opening and closing tables.
Sometimes an error occurs that requires the user-defined transaction to be aborted.
Trafodion SQL will automatically abort the transaction and return an error indicating that the transaction was rolled back.
DDL statements are not currently supported in transactions.
That means that you cannot run this statement inside a user-defined transaction (BEGIN WORK…COMMIT WORK) or when AUTOCOMMIT is OFF.