what is a collection?

2 Answers  

---

What is dclgen in db2?

0 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

How do you eliminate duplicate values in db2?

0 Answers  

---

What is clone table?

0 Answers  

---

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---

what is parm utility

2 Answers   IBM,

---

How will you return the number of records in table?

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,

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---