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 catalog database in db2?

0 Answers  

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

What is a result table?

1 Answers  

---

What is a db2 package?

0 Answers  

---

How many types of page locks can be held in db2?

0 Answers  

---

---

What is a clustering index?

2 Answers  

---

Can you use max on a char column?

0 Answers  

---

What is syscat in db2?

0 Answers  

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

How can deadlocks be resolved?

0 Answers  

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---