The validate command running on a custom SQL query returns the error message AWSWUI0331E
You are creating a Custom
SQL report, and you run the Validate command
to check your query. The validate fails and the following error message
is returned:
AWSWUI0331E The SQL query could not be validated. The database internal message is:
[ibm][db2][jcc][10103][10941] Method executeQuery cannot be used for update.
Cause and solution:
The validate failure is caused
by a syntax error in the query statement,
for example, a typing error, such as:
sele Workstation_name,Job_name,Job_start_time from MDL.JOB_HISTORY_V
where Workstation_name like 'H%'
In this query, sele is
written in place of select.Verify the SQL query is correct and, optionally, try to run the same query from the DB2® command line to get additional details.