When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---

When would you prefer to use VARCHAR?

3 Answers  

---

What is buffer pool in the db2 database?

0 Answers  

---

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---