What do you need to do before you do EXPLAIN?
Answer / s
Create the Plan_table to holds the results of the explain.
| Is This Answer Correct ? | 5 Yes | 0 No |
When is the skeleton cursor table created?
What is referential integrity?
What is nvl in db2?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
How do I add a column to an existing table in db2?
can we update the table by using cursors can anyone post the query?
What is the difference between plan and package in db2?
What is a db2 table?
Explain how can you do the explain of a dynamic sql statement?
What is cursor?
What do you do to keep the cursor from closing after a commit?
What is Reorg Recovery? when will you run it?