Answer Posted / regu

select distinct salary from table name hwre rownum <=10

Explain how can you do the explain of a dynamic sql statement?

654

---

How is a typical db2 batch pgm executed?

642

---

What is a system catalog table in db2?

590

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

714

---

How do you select a row using indexes in db2?

647

---

---

i want to maintain uniqueness on pdf without make lf??????????

1637

---

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

603

---

What are the various isolation levels possible?

649

---

What is a plan and package in db2?

625

---

What is sqlca’s maximum length?

678

---

Explain packages.

666

---

Is db2 relational database?

574

---

List out the buffer pools in db2

632

---

What are union and union all?

541

---

What is cursor in dbms?

595

---