How do you do the EXPLAIN of a dynamic SQL statement?
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 is the difference between where clause and having clause
how will you retrieve first record in table
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
i have a db2 variable how do u declare tht into working storage section ?
What is -904 sql code? How to resolve it?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to find last record before record through SQLRPGLE?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
What does db2 plan contain?
What are simple, segmented and partitioned table spaces ?
How many buffer pools are there in DB2?