Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  

---

How to solved 818 error

4 Answers   Keane India Ltd, Wipro,

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

What is a view? Why use it?

3 Answers  

---

What is meant by repeatable read?

4 Answers  

---

can we drop column from a table

7 Answers   INDUS,

---

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

Explain the EXPLAIN statement?

1 Answers  

---