Answer / Kanhaiya Lal

DB2 is an acronym for Database 2, indicating it is the second version of the IBM Database Management System.

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

1 Answers   Infosys,

---

What is a clustering index?

2 Answers  

---

what is cursor stability?

2 Answers   IBM,

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

Can one database have multiple instances?

1 Answers  

---

What is sqlcode -922 ?

2 Answers  

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

i want to delete 20th million record how ?

4 Answers   IBM,

---