Answer Posted / a

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

that's it.

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7534

---

How does cobol compile db2 program?

610

---

What is alias in db2?

574

---

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

1656

---

What is precompiler in db2?

589

---

---

How do I delete a column in db2?

686

---

How to view db2 table structure?

597

---

What is ibm db2 used for?

605

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1599

---

Why do we use cursor?

599

---

What is dclgen (declaration generator)?

605

---

What is db2 command?

586

---

What is db2 connect?

612

---

What is node in db2?

610

---

How to find schema of a table in db2?

574

---