DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

What is the use of with ur in db2?

0 Answers  

---

How to check sequence on a table in db2?

0 Answers  

---

How to find the maximum value in a column in the db2 database?

0 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

How to view db2 table structure?

0 Answers  

---

What is the use of commit in db2?

0 Answers  

---

Give the COBOL definition of a VARCHAR field.

2 Answers  

---

Name some fields from SQLCA

1 Answers  

---

What is the self-referencing constraint?

2 Answers  

---