While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

What is a system catalog table in db2?

0 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

How many sub queries can you combine together ?

4 Answers   IBM,

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

Give some example of statistics collected during RUNSTATS?

1 Answers  

---

What is a bind card?

0 Answers  

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

What is QUIESCE?

2 Answers  

---

What's The Error Code For Unique Index Voilation?

0 Answers   IBM,

---

How do you pull up a query which was previously saved in qmf?

0 Answers  

---