Explain the benefits you can get from mainframe connect?

0 Answers  

---

Which one allows duplicate values Union or Union All ?

3 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

What is nvl in db2?

0 Answers  

---

Which catalog table stores referential constraints?

1 Answers  

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

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  

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

Explain about mirror activator disk mirroring?

0 Answers  

---

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---