Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

---

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

1 Answers  

---

How does coalesce work?

0 Answers  

---

What is db2 and what is the use of db2 optimizer?

0 Answers  

---

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

What is db2 look?

0 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

Mention the downsides of page level lock.

0 Answers  

---