How do you do the EXPLAIN of a dynamic SQL statement?

Answers were Sorted based on User's Feedback



How do you do the EXPLAIN of a dynamic SQL statement?..

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

How do you do the EXPLAIN of a dynamic SQL statement?..

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

Post New Answer

More DB2 Interview Questions

what is the difference between where clause and having clause

2 Answers   IBM,


how will you retrieve first record in table

1 Answers   UST,


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?

2 Answers  


i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,






What is -904 sql code? How to resolve it?

3 Answers  


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  


How to find last record before record through SQLRPGLE?

1 Answers   IBM,


if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  


What does db2 plan contain?

0 Answers  


What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,


How many buffer pools are there in DB2?

2 Answers  


Categories