Answer / srini

In static linking the load modules of the called/sub
programs are also loaded into main/calling program load
module,and incase of dynamic linking the load modules of
main/calling and sub/called programs are kept seperate and
will be loaded dynamically when ever there is a perticular
call statement.

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

How to resolve deadlock issue

5 Answers   IBM,

---

How would one remove old reorg information from the DB2 catalog?

2 Answers  

---

what is datacom db?

2 Answers   CSC,

---

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  

---

what is db2 restart?

0 Answers  

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---

How to find schema of a table in db2?

0 Answers  

---

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

---

What is buffer pool?

0 Answers  

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---