Mention the downsides of page level lock.

0 Answers  

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

What is the difference between static and dynamic SQL?

1 Answers  

---

What are the uses of db2 optimizer?

0 Answers  

---

What is the advantage in De-normalizing tables in DB2?

0 Answers  

---

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---

What's The Error Code For Unique Index Voilation?

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,

---