Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6181 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 ibm db2 connect?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
what is the difference between declaring the cursor in WS section and Procedure division?
What is null in db2?
How to resolve -504 sql code in DB2?
How to view db2 table structure?
What are the Isolation levels possible ?
What is image copy?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
Can you use max on a char column?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
COBOL 
