Answer / s

yyyy mm dd hh mm ss nnnnnn
2 + 1 + 1 +1+ 1+ 1+ 3 = 10
Internal representation of TIMESTAMP is a string of 10
bytes. One byte for two packed decimal digits.

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  

---

What is db2 stogroup?

0 Answers  

---

Give a brief description of db2 isolation levels?

0 Answers  

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

What is the database descriptor?

2 Answers  

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

---

When do you specify the isolation level? How?

1 Answers  

---