Answer / ravi & dhana

10 HNAME.
49 HNAME-LEN PIC S9(4) USAGE COMP.
49 HNAME-TEXT PIC X(10).

Answer / a

its
10 HNAME.
49 HNAME-LEN PIC S9999 USAGE COMP.
49 HNAME-TXT PIC X(10).

that's it.

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---

What is the difference between oracle and db2?

0 Answers  

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

When reorg is used?

0 Answers  

---

What is performance tuning db2?

0 Answers  

---

Explain about cursor stability?

0 Answers  

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,

---