Answer Posted / bharath

select sal from(select ename,sal rownum from emp orderby sal
desc group by sal,rownum)where topsal='&nth';

What is the use of reorg in db2?

1089

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1065

---

How does db2 sample database connect?

1035

---

Give a brief description of db2 isolation levels?

1076

---

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

1130

---

What is db2? Explain.

1052

---

What is the picture clause of null indicator variable?

1139

---

Why do we use cursor?

1106

---

What is the reason behind not using select * in embedded sql programs?

1120

---

What do you mean by storage group (stogroup)?

1043

---

What is a db2 collection?

1053

---

What is the difference between cursor stability and repeatable read isolation levels?

1183

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2538

---

Which command is used to remove all rows from a table?

1119

---

Which components manage deadlocks in db2?

1074

---