Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6195 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 db2 isolation?
What is the difference between nvl and coalesce?
wht steps we need will coding cobol and db2 pgm ?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What are types of indexes?
How could one combine a set of incremental image copies into a single copy?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
What are the functions in DB2?
What is dbrm in db2 database?
What is database manager in db2?
what is REORG? what is the use?
what is the soft code for deadlock ?
COBOL 
