Answer / saikishore

select TIMESTAMP(DATECOLUMN)
FROM TABLE1

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

What is lock escalation in db2?

0 Answers  

---

What will the FREE command do to a plan?

2 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

What is DB2 (IBM Database 2)?

3 Answers  

---

What is Declaration Generator(DCLGEN)?

1 Answers  

---

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---

What are the Isolation levels possible ?

5 Answers  

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

What is reorg in DB2

3 Answers   Virtusa,

---