What is sqlca’s maximum length?

0 Answers  

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

Explain package in db2 and its advantages?

0 Answers  

---

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

how do you resolve -805?

3 Answers   HCL,

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

What are delete-connected tables?

1 Answers  

---

What is the purpose of rollback and commit?

0 Answers  

---