setting QUERYNO for EXPLAIN output in applicaton program

vini_srcna

Hi Guys,

I have a question on Explain. We know that when the package/Plan is bound with EXPLAIN(YES) and if there is a plan table, we get the explain output into the plan table. The explain output gives the QUERYNO for each EXEC SQL statement in the program based on the Precompiler listing statement no.

When ever we change the program, QUERYNO keeps on changing. I have heard that there is a way that we can keep the QUERYNO constant so that it will be very easy to see the difference in ACCESS PATH. It will be easy to figure out which query is making the difference easily.

Is that by using EXPLAIN PLAN SET QUERYNO in the application program..?. It didnt work for me. I think I wasn't right. Please through some light on this. Thanks in advance.!