When processing more than one SQL statement using function "Execute Explain Plan" only the first one will be highlighted.
When moving from the explain plan result for statement 2 and the one for statement 3 , the statement the explain plan is for it is not highlighted.
See an example of the statements being used:
select * from sysibm.sysdummy1;
select current server from sysibm.sysdummy1;
select current timestamp from sysibm.sysdummy1;
WORKAROUND
Remove the extra spaces between the FROM and the name of the table :
select * from sysibm.sysdummy1;
select current server from sysibm.sysdummy1;
select current timestamp from sysibm.sysdummy1;
STATUS
Waiting for fix in a future release of Toad for DB2 ZOS
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center