Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6190 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 |
Define check constraint.
What is dpf in db2?
what is SPUFI ?
What are data types?
What's the maximum number of volumes that can be added to a STOGROUP?
What are PACKAGES ?
What is the maximum number of columns in a db2 table?
What is lock escalation in db2?
What is buffer pool and list some of them?
Which catalog tables contain authorization information?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
How do you pull up a query which was previously saved in qmf?
COBOL 
