in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

What is reorg in DB2

3 Answers   Virtusa,

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  

---

---

What is ALTER ?

3 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  

---

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,

---

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

What is the use of predicate?

0 Answers  

---