what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

What are foreign keys?

1 Answers  

---

What is COPY PENDING status?

6 Answers  

---

wht are the restrictions for union ?

2 Answers   CTS,

---

Explain dclgen.

0 Answers  

---

Why do chiropractors use drop table?

0 Answers  

---

Give the name of some fields form sqlca.

0 Answers  

---

What can the Locate option of the Repair Utility accomplish?

2 Answers  

---

What is check constraint in db2?

0 Answers  

---

What will happen, while trying to close the closed cursor.

1 Answers  

---

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

3 Answers   UST,

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---