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

how to check the table is empty or not?

3 Answers   IBM,


What is load utility in db2?

0 Answers  


How can you count the number of rows from a table tab?

0 Answers  


How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,


How can you get the number of rows impacted by the last executed query?

1 Answers  


What is subquery ?

6 Answers  


how can we retrieve the 100 records of the file ?

2 Answers   IBM,


When do you specify the isolation level?

0 Answers  


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  


If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,


Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,


What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  


Categories