How to capture "Explain SQL" output
Posted on 2008-09-30
How do I capture ALL of a StoredProcs "Explain SQL" output?
When I run "Explain SQL", I get a listbox-like display.
When I try to Highlight, Copy and Paste ...
the capture stops at a line with little squares embedded in the line and the remaining text is NOT captured.
little squares appear where I have X's below
SQL402B Table 3XXXXXX used in hash join step 1.
And capture stops ...
I'm using iSeries Navigator V5R3M0