Error Dropping or Creating a DB2 for z/OS Database

If you run one of the following commands against a DB2 for z/OS system:

DROP DATABASE xxxxx

or

CREATE DATABASE xxxxx

you can get the following error message:

07003(-518)[IBM][CLI Driver][DB2] SQL0518N The statement named in the EXECUTE statement is not in a prepared state or is a SELECT or VALUES statement. SQLSTATE=07003

The reason for this is that these type of statements cannot be run with the Prepare / Execute method that AQT normally uses for running SQL.

To run these statements, go to Options > Technical Parameters and check the option Use SQLExecDirect. After this, these two statements will run OK.

You may then wish to uncheck Use SQLExecDirect option to return AQT to its normal behaviour.