Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6086 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 is dclgen in db2?
What is the function of buffer manager?
What is the syntax required for the creation of a cursor?
What kind of database is db2?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Explain in detail about buffer manager and its functionalities?
How to resolve -805 error in DB2?
Is the primary key a clustered index?
What is query_cache_limit?
What are the 4 environments which can access DB2 ?
Explain how can you do the explain of a dynamic sql statement?
COBOL 
