Answer / akbar

Use EXPLAIN to list out the access paths of several
different codes you come up with and choose the path that
got executed within the least time.

Which catalog table stores referential constraints?

1 Answers  

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---

What is db2 purescale?

0 Answers  

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

What is an intent lock?

3 Answers  

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---

Define declaration generator (dclgen).

0 Answers  

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

How to create a table using embedded sql?

1 Answers  

---