We are not able to use the Explain Execute Plan for DB2 z/OS. We had aliases set up for the plan tables for our users. Our users are numeric and we get error:
Error 42604 "The numeric literal "12345.PLAN_TABLE" is not valid. When investigating this issue we found that Toad added quotes ( or sent the userID without qutoes, when DB2 was expecting quotes).
Is there any way that I can change the way the request is sent to DB2, maybe changing a registry setting in Toad?
We are using Toad expert Edition version 7.2