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.

How do you stop a db2 database in linux?

1014

---

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

2070

---

What is a db2 package?

1058

---

Explain various types of locks in db2?

1151

---

What is db2 command?

1037

---

What does sqlcabc has?

1055

---

How to restart a DB2 program?

1902

---

What are the bind parameters ibm db2?

1053

---

What is buffer pool and list some of them?

1028

---

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

1045

---

Is db2 a mainframe database?

1000

---

What action db2 takes when a program aborts in the middle of a transaction?

1156

---

Give a brief description of db2 isolation levels?

1074

---

What is collection in db2 bind?

1017

---

What is the difference between oracle and db2?

1109

---