How to capture "Explain SQL" output

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
LVL 5
volkingAsked:
Who is Participating?
 
momi_sabagConnect With a Mentor Commented:
its in the schema of the user you used to run the explain statement
0
 
momi_sabagCommented:
all explain output is inserted into a table called plan_table
you can find it there
0
 
volkingAuthor Commented:
@Momi
Thanks!
... is PLAN_TABLE in a specific Schema/Library?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.