Describe what a storage group(STOGROUP) is?

2 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

What is db2 isolation?

2 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---

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  

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

What is the use of db2 optimizer?

0 Answers  

---

What is the FREE command?

1 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---

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,

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---