Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  

---

What is a recovery log?

1 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

How would the varchar column remarks defined?

0 Answers  

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

How many sub queries can you combine together ?

4 Answers   IBM,

---

how to check the table is empty or not?

3 Answers   IBM,

---

What are the various locking levels available?

3 Answers  

---

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

4 Answers  

---

Explain the function of data manager.

0 Answers  

---

Explain db2.

0 Answers  

---

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

---