MVSFORUMS.com

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

Hi all,

After a BIND with EXPLAIN(YES) i have information on PLAN_TABLE. In that table, the information about every sentence is identified with QUERYNO.

How can i link the sentence (select from... or update, etc) with the QUERYNO?

For example, i have the path access of QUERYNO 1621. But there is a easy way to get which sentence has this access path?

Kind regards.

Bithead · Posted: Mon Oct 18, 2004 3:23 pm Post subject:

Try looking for an SQL-STMT-NUM with a value of +1621 in the output from the compile. This will give you an 01 level for an SQL-PLISTxx entry. Look for that number in the code (Skip all the entries in the SQL-INITIAL section) and it should have saved the original SQL as a comment.