|
|
|
|
|
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.
