When running a script in SQL Editor using F9 or the green arrow icon:
"ERROR [42601][IBM][CLI Driver][DB2/6000] SQL0104N An unexpected token 'END-OF-STATEMENT' was found following 'CUST'. Expected tokens may include: "JOIN <joined_table>". SQL STATE=42601"
F9 will only execute the current SQL statement where the cursor is located. Some errors such as missing "END-OF-STATEMENT" may occur since it never reached the end statement.
RESOLUTION 1:
Execute with F5, which executes the whole script.
RESOLUTION 2:
Highlight the whole script and Execute with F9.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center