How do I delete a table in database?

0 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---

Explain about cursor stability?

0 Answers  

---

---

Define declaration generator (dclgen).

0 Answers  

---

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

---

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

0 Answers  

---

Explain the function done by data manager?

0 Answers  

---

How to fetch the last row from the table in SQL (db2)?

0 Answers  

---

What is the difference between TYPE 1 index & TYPE 2 index

1 Answers   IBM,

---

What is an instance in db2?

0 Answers  

---