Update command

1 Answers  

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

What is the purpose of rollback and commit?

0 Answers  

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

---

What is a bind in db2?

0 Answers  

---

What is a subselect? Is it different from a nested select?

1 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

what is the difference between where clause and having clause

2 Answers   IBM,

---

Mention the various locks that are available in db2.

0 Answers  

---

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  

---

What does the CHECK Utility do ?

1 Answers  

---