Answer Posted / shaikshavali

if u r using PL/SQL

select distinct id from subs_contacts
where rownum<=10
order by id desc

How do I optimize a query in db2?

1104

---

What is collection in db2 bind?

1019

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2857

---

What is the use of db2?

1058

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278

---

What are host variables in db2?

1073

---

What is bind plan?

1054

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1440

---

What is the syntax for FETCH in DB2 ?

1219

---

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?

2536

---

How do I create a view in db2?

1027

---

What is runstats utility in db2?

1023

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

---

What do you mean by storage group (stogroup)?

1042

---

How connect db2 database to datastage?

1247

---