When trying to get an explain plan for a query in the editor window, a pop-up window is displayed with the following error:
ERROR [42601] [IBM][DB2/AIX64] SQL0104N An unexpected token "END-OF-STATEMENT" was found following "Commit#". Expected tokens may include: "JOIN <joined_table>". SQLSTATE=42601
This issue does not seem to be a Toad issue. I can be replicated using applications other than Toad. To verify this on your machine, you can run the following statement in the DB2 Command Center.
EXPLAIN PLAN SET QUERYNO = [unique ID for query, if PLAN_TABLE is empty you can use a value of 1] FOR [your SELECT statement];
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center