Answer Posted / kumar

Hi ............
try this one ....might be a logical one ... but have to
give customers what they want.....

Select count(*) into :ws-count from emp with ur;

Declare CURSOR cursor1 for
Select *(if possible better code all fields)
from emp where count(*) < :ws-count;
Open cursor
Fetch cursor.

Declare CURSOR cursor2 for
Select *(if possible better code all fields)
from emp where

count(*) >= :ws-
count;
Open cursor
Fetch cursor.

Is ibm db2 free?

947

---

Which isolation level provides maximum concurrency?

1088

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2175

---

How can deadlocks be resolved?

887

---

Can we update view in db2?

943

---

Define db2.

1061

---

What is a db2 collection?

981

---

Explain in detail about buffer manager and its functionalities?

990

---

Is ibm db2 open source?

1010

---

Define sqlca.

1052

---

Can you use max on a char column?

1026

---

Is db2 a database?

906

---

What is the use of value function?

1070

---

How to execute stored procedure in db2 command editor?

983

---

How to retrieve rows from a db2 table in embedded sql?

1320

---