Transaction control enforces database integrity by ensuring that batches of SQL operations run completely or not at all. The transaction control commands are BEGIN, COMMIT, and ROLLBACK.
IBM® Netezza® SQL supports auto-commit transaction mode. In this mode, all SQL commands commit when you run them. If the system encounters a SQL command before a BEGIN SQL command, it runs the SQL command in auto-commit transaction mode. If the system encounters a BEGIN SQL command, it runs all successive SQL commands within the transaction. To end a transaction, you must issue a COMMIT or ROLLBACK SQL command.
ERROR: CREATE DATABASE: may not be called in a transaction block or stored procedure