Answer / s

The CREATE statment is stored in the SYSIBM.SYSVIEWS

What is the purpose of rollback and commit?

0 Answers  

---

What is a correlated sub query?

2 Answers  

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

What is role in db2?

0 Answers  

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

what is rebinding ?

1 Answers   IBM,

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

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 static sql? what is dynamic sql? Give me details

3 Answers  

---