Answer / s

IN subselect will return rows that match the values in the
IN list. EXISTS will return rows if the subselect return a
true value.

What is lock escalation?

2 Answers  

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

what is rebinding ?

1 Answers   IBM,

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

---

How will you return the number of records in table?

0 Answers  

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 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,

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

---

what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,

---

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,

---