When trying to optimize a statement, a "This type of SQL statement is not supported" error is given.
The query runs w/o problems. From Toad the query is sent to optimizer, and from there, use the green arrow icon to optimize, but it never optimizes and just gives the error.
Sample statement:
SELECT trv.CUST_633,
trv.EVNT_CD,
trv.POOL_ID
FROM evt_hist trv
WHERE inv.evnt_dt > (current date - 28 DAYS)
AND trv.evnt_dt != current date
AND trv.EVT_CD IN ('DD', 'AP')
AND (trv.cust_333, trv.cust_ST) = (trv.CITY_333, trv.cvn_ST)
The specific syntax is not supported.
WORKAROUND:
Adjust the syntax of the where condition.
If the syntax of the where clause is adjusted, the statement optimizes without any problems.
Originally....
(trv.cust_333, trv.cust_ST) = (trv.CITY_333, trv.cvn_ST) -- does not optimize
Changes to....
(trv.cust_333 = trv.CITY_333 AND trv.cust_ST = trv.cvn_ST) -- does optimize
STATUS:
Waiting for fix in a future version of Quest SQL Optimizer for DB2
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center