What are the two types of logging in the db2 database? Explain them.

0 Answers  

---

How to view db2 table structure?

0 Answers  

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

What is the meaning concurrency in the db2 database?

0 Answers  

---

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

What is database reorganization?

0 Answers  

---

What is check constraint. Explain with example.

0 Answers  

---

Why select is not preferred in embedded sql programs?

0 Answers  

---

Explain an outer join?

1 Answers  

---

What are concurrency issues?

0 Answers  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---