Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6205 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha dasari
we could replace the unknown values with a "?"
eg:
select name
from database
where name = ?
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / mehdee
- When we issue an EXPLAIN as of the BIND like EXPLAIN
(YES), then results to analyze the path will go into 3 DB2
tables: PLAN_TABLE, DSN_STATEMENT_TABLE &
DSN_FUNCTION_TABLE. And you can do:
- select * from fhtdev.plan_table; And columns are
defined in DB2 Developers Guide EXPLAIN.
| Is This Answer Correct ? | 0 Yes | 1 No |
What do you mean by between and in? Is between inclusive of specified range values?
how to resolve -811
Describe the elements of the SELECT query syntax?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
Is Cursor exicutable ?
What can the SET option of the Repair Utility accomplish?
Differentiate between cs and rr isolation levels? Where do you specify them?
How to view db2 table structure?
How do I add a column in db2?
define clustering index.
Could anyone clearly explain the diference between sub query and correlated sub query?
What is the difference between base table and view?
COBOL 
