Explain how can you do the explain of a dynamic sql statement?
- 1 Answers
- 1205 Views
- I also Faced
- E-Mail Answers
Answer / Prince Gupta
In DB2, you cannot directly use EXPLAIN on a dynamic SQL statement. However, you can create an explanation plan for each component of the dynamic SQL and then combine them manually. Here's an example:n
1. Create a prepared statement for each subquery:n```sqlnPREPARE stmt1 AS SELECT column_name FROM table_name WHERE condition1;```n
2. Explain the prepared statement:n```sqlnexplain PLAN FOR stmt1;```n
3. Repeat steps 1 and 2 for all subqueries.n
4. Finally, combine the explanation plans manually.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a DBRM, PLAN ?
What is bind package and plan in db2?
What are the isolation levels possible ?
How to insert more than one record using insert?
What is ACQUIRE/RELEASE in BIND?
How to access db2 tables in mainframe?
what is datacom db?
What is dbrm? What it contains? When it will be created?
Can you define an Index if the table size less than 10 PAGES?
What does the sqlcode of -818 pertain to?
Mention data types used in db2 ?
What is DCLGEN ?
COBOL 
