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

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11740

---

What does db2 stand for?

1087

---

What is bufferpool in db2?

1093

---

What is lock escalation in db2?

1078

---

define clustering index.

1065

---

What is the purpose of rollback and commit?

1275

---

List out the three types of page locks that can be held.

1191

---

What is dbrm? When it will be created?

1084

---

Explain about cursor stability?

1103

---

What is the difference between bind and rebind in db2?

1505

---

How do I add a column to a table in db2?

1155

---

How do you stop a db2 database in linux?

1051

---

What is commit in db2?

1100

---

Explain about rct.

1128

---

What are the rules for db2 programming?

1151

---