I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

What is an alias and how does it differ from a synonym?

3 Answers  

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---

Can a Db2 table data be retrived through JCL?

4 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

How many buffer pools are there in DB2?

2 Answers  

---

How can we retrieve the total number of records in RPG & CLLE?

0 Answers  

---

How do you stop a db2 database in linux?

0 Answers  

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

How can you quickly find out the # of rows updated after an update statement?

0 Answers  

---