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 dbrm? What it contains? When it will be created?

1051

---

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

2158

---

Is the primary key a clustered index?

1150

---

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

1160

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2727

---

Can one database have multiple instances?

1057

---

What is rct?

1238

---

what is the role of the cursor in db2?

1069

---

What is a bind in db2?

1047

---

What types of tables are there in the db2 database?

1061

---

Is ibm db2 open source?

1079

---

Is db2 free?

1099

---

What is a db2 table?

1022

---

What is nvl in db2?

1099

---

Comment whether the cursor is closed during commit or not.

1110

---