How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

What is a base table?

2 Answers  

---

What is difference between alias and synonym in db2?

0 Answers  

---

What is the purpose of rollback and commit?

0 Answers  

---

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

What is the difference between cursor and select statement?

0 Answers  

---