Trying to run Explain on a Db/2 query, but running into an error.
An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-104", SQLSTATE "42601" and message tokens "END-OF-STATEMENT|153875 FOR ORDER BY|JOIN ".. SQLCODE=-727, SQLSTATE=56098, DRIVER=4.21.29
When we try to explain the Query without selecting the text we get the error pasted below:
Empty query string
Please select the text you want explained and click the “Explain Execution Plan“.