Answer / s

EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.

What is the physical storage length of time data type?

0 Answers  

---

Return code 100 means?

6 Answers   Cap Gemini,

---

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---

What is DCLGEN ?

2 Answers  

---

What is copy book?

1 Answers   Thomson Reuters,

---

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---

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,

---

Define db2 and its databases?

0 Answers  

---

What is ibm db2 used for?

0 Answers  

---

Can a Db2 table data be retrived through JCL?

4 Answers  

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

What is coalesce in db2?

0 Answers  

---