the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

What is database alias db2?

0 Answers  

---

What happens to the PLAN if index used by it is dropped?

1 Answers  

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

Which command is used to remove all rows from a table?

0 Answers  

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---

What is page size in db2?

0 Answers  

---

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

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

0 Answers  

---

What is a thread?

3 Answers  

---