In Toad for DB2 5.1, I went to Tools | Options | Database | DB2 and change the script delimiter to '$.'
When I run any query and click on the Explain Plan, I get this error:
ERROR [42601] [IBM][DB2/NT] SQL0104N An unexpected token "END-OF-STATEMENT" was found following "Commit$". Expected tokens may include: "JOIN <joined_table>".
,
WORKAROUND: Avoid using $ as a delimiter.
STATUS: Waiting for fix in a future release of Toad for DB2.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center