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

How many types of page locks can be held in db2?

1021

---

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

11663

---

What is the difference between db2 and oracle?

1108

---

What is bind and rebind in db2?

1124

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3188

---

Which are the db2 tools to protect integrity of the database?

1110

---

Explain what are the various isolation levels possible?

1029

---

Define buffer pool.

1034

---

What is cursor stability in db2?

1337

---

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

7530

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1083

---

What is a bind in db2?

1022

---

What is the role of union all and union

1104

---

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

1068

---

What is meant by dclgen?

1095

---