Toad World® Forums

Enhancement? TOAD4DB2 does not show explain plan when sentence is a Merge.-


#1

Hi,

When you try to visualize an explain plan and the Sentence is a common table expression, you get a blank screen.

Is this feature scheduled to be included in future version of TOAD?


#2

Please tell me your version of Toad and DB2, and send the SQL.


#3

db2 are V8, V9 and V9.5

Toad with this bug are all to 4.7.0.556 (current. previous used were 4.6 and 4.5)

the SQL is any Merge.

You have merge syntax here:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0010873.htm

Example for the easier to test: delete
With 2 tables

MERGE INTO SCHEMA.TABLE1 AS a
USING (SELECT id FROM TABLE2
GROUP BY id) AS t
ON a.id = t.id
WHEN MATCHED THEN
DELETE;


#4

Thank you for the details Jose.

I’ve opened case 82,165 to track this issue.


#5

Thanks.