Answer / mahi

I think it can be done with the help of arrays or Tables(in
cobol)

Answer / krishna reddy

we must know max no of records we want to fetch.
suppose max no record 50...

01 host-variable.
02 employee occurs 50 times.
05 eno pic 9(4).
05 ename pic A(20).
05 esal pic 9(5).

Declare cursor c1 for select eno,ename,esal from emp;

open c1.

fetch c1 into :host-variable.

Answer / anto

The question is to fetch multiple records...not multiple
row(s)..
So this is possible with single select query.

Answer / srini

It is possible in DB2 V8

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  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

Why db2 is called db2?

0 Answers  

---

How many buffer pools are there in DB2?

2 Answers  

---

Are views updatable ?

4 Answers  

---

Explain in brief how does db2 determine what lock-size to use?

0 Answers  

---

What is explain plan in db2?

0 Answers  

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  

---

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  

---

What is cursor stability in db2?

0 Answers  

---