Most SQL statements are acceptable in batches, with the exception of the following:

• ALTER DATABASE (syntax 3 and 4)
• CONNECT
• CREATE DATABASE
• CREATE DECRYPTED FILE
• CREATE ENCRYPTED FILE
• DISCONNECT
• DROP CONNECTION
• DROP DATABASE
• FORWARD TO
• Interactive SQL commands such as INPUT or OUTPUT
• PREPARE TO COMMIT
• STOP ENGINE

You can use COMMIT, ROLLBACK, and SAVEPOINT statements within procedures, triggers, events, and batches with certain restrictions. See Transactions and savepoints in procedures and triggers.

For more information, see the Usage for each SQL statement in SQL statements.