I'm working with Data Studio(stand-alone) Version 22.214.171.124.
When retrieving SQL from a bound package on DB2 V9 zOS, I notice that
the SQL has parameter markers (?) as well as host variables (H) for every host variable found in the SQL statement. For example, the SQL from
the package looks like SELECT COL1, COL2 from table where col1 = ?H
Is this a bug or is there a way to configure this so that the SQL only displays one or the other (parameter marker or host variable). This is causing errors when trying to explain the SQL. I have to manually remove
either the host variable or the parameter marker to get the EXPLAIN to work.
Pinned topic Optim Query Tuner parameter marker host variable
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-09-29T04:54:08Z at 2010-09-29T04:54:08Z by zhaoguob
zhaoguob 27000256SM3 Posts
Re: Optim Query Tuner parameter marker host variable2010-09-29T04:54:08ZThis is the accepted answer. This is the accepted answer.I am so sorry and this is a bug of Data Studio(stand-alone) Version 126.96.36.199.
Here is a workaround. You can create a filter in the view of "Capture sql for tuning" with your filter conditions, then select your statement that you want to tune( host variable :H should be there) then click "save for tuning" button.
FYI, here is the steps