Answer Posted / amarnath reddy

use unions, merge the rows from morethan one table.
Ex: select accno.,accname from bank1;
union
select accno.,accname from bank2;

use Joins, merge the columns from morethan one table.
Ex: select i.accno., d.bcode from banktab i, dtlstab d
where i.bcode=d.bcode;

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

1089

---

List down the data types in the db2 database.

1097

---

What is the result of open cursor statement?

1071

---

What are the two types of logging in the db2 database? Explain them.

1055

---

Explain about cursor stability?

1022

---

Explain dclgen.

1180

---

What is scrollable cursor in db2?

1040

---

How to check last update on table in db2?

1039

---

What is precompiler in db2?

995

---

How do we specify index to include or not during bind process.

2107

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1135

---

What is runstats utility in db2?

1000

---

Explain correlated sub-queries.

1010

---

What are union and union all?

970

---

What is dbrm? What it contains? When it will be created?

1029

---