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.

List down the data types in the db2 database.

1112

---

On which levels locks can be applied?

1121

---

What is plan in cobol db2?

1130

---

How does coalesce work?

1010

---

How would you find out the total number of rows in a db2 table?

1048

---

What are the various isolation levels possible?

1114

---

Mention the various locks that are available in db2.

1031

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2322

---

What is host variable in db2 cobol?

1070

---

How to find schema of a table in db2?

1008

---

What is universal database?

1066

---

What do you mean by between and in? Is between inclusive of specified range values?

1088

---

What is the syntax for FETCH in DB2 ?

1203

---

What language is db2 written in?

1039

---

What is isolation level in db2?

997

---