Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

How do I add a column in db2?

0 Answers  

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

What is read-only cursor?

1 Answers  

---

What is the use of predicate?

0 Answers  

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

What is the use of with ur in db2?

0 Answers  

---

what is rebinding ?

1 Answers   IBM,

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---