Answer Posted / babji009

A view is a virtual table made up of data from base
tables and other views, but not stored separately.
Ex:
CREATE VIEW GOOD1_SUPPLIERS
AS SELECT S#, STATUS, CITY
FROM S
WHERE STATUS > 15;
SELECT * FROM GOOD1_SUPPLIERS;

---------+---------+---------+---------+-----------
SELECT * FROM GOOD1_SUPPLIERS;
---------+---------+---------+---------+-----------
S# STATUS CITY
---------+---------+---------+---------+---
S3 40 PARIS
S4 110 LONDON
S8 30 ATHENS
S7 20 U.S.A

What is db2? Explain.

986

---

What are catalog tables in db2?

979

---

What is the role of union all and union

1068

---

Why do we use cursor?

1047

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2864

---

How to check table size in db2 sap?

975

---

What is with ur in db2?

1242

---

What is db2 plan table?

992

---

How to execute stored procedures?

1061

---

What type of database is db2?

910

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1024

---

What is cursor with hold option in db2?

1009

---

What are union and union all?

920

---

What is database reorganization?

1052

---

What is the maximum number of columns in a db2 table?

1213

---