In this post, you’ll learn about the DB2 error 2762-The ‘CREATE TABLE’ command is not allowed within a multi-statement transaction in the ‘tempdb’ database. and the reason why you are receiving the error message and how to fix it
How does this Error Message Looks like
2762 – The ‘CREATE TABLE’ command is not allowed within a multi-statement transaction in the ‘tempdb’ database.
Reason for the Error & Solution
This may happen when running the schema tool against a Sybase database that is not configured to allow schema-altering commands to be executed from within a transaction. This can be enabled by entering the command sp_dboption database_name,”ddl in tran”, true from isql. See the Sybase documentation for allowing data definition commands in transactions .