How can you do the explain of a dynamic sql statement?
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between alias and synonym in db2?
Can I use LOCK TABLE on a view?
What is a buffer in memory?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
What can the Locate option of the Repair Utility accomplish?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What is explain plan in db2?
What is the function of buffer manager?
What are the uses of db2 optimizer?
Name the various locking levels available?
What are types of indexes?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?