Background
Trying to run Explain on a Db/2 query, but running into an error.
Error
Error Image
Error Text
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
Troubleshooting
Unselected Text
When we try to explain the Query without selecting the text we get the error pasted below:
Image
Text
Empty query string
Remediation
Select Text
Please select the text you want explained and click the “Explain Execution Plan“.