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

define clustering index.

1072

---

What is phantom read in db2?

1226

---

How to test SQL -911 error while developing COB-DB2 program

7673

---

How to fetch the last row from the table in SQL (db2)?

1698

---

How to create db2 table in mainframe?

1220

---

List some fields from sqlca?

1107

---

What is the picture clause of null indicator variable?

1183

---

How to create backup table in db2?

1150

---

What is a trigger in the db2 database?

1144

---

Explain db2.

1087

---

When the like statement is used?

1284

---

Can we insert update delete in view?

1030

---

How to find the maximum value in a column in the db2 database?

1132

---

What is the default page size of buffer pools?

1171

---

What is the difference between nvl and coalesce?

1110

---