Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6203 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 meant by concurrency?
What do you mean by storage group (stogroup)?
Explain in brief how does db2 determine what lock-size to use?
Explain dclgen.
What is db2 stogroup?
when does the SQL statement gets executed when you use cursor in the application programming ?
What is dbrm?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
Can you use max on a char column?
Define declaration generator (dclgen).
COBOL 
