Answer / 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

Answer / om yadav

after a table is created and populated with data, it may
become necessary to prevent all users from accessing all
column of a table, for data security reasons.
To reduce redundant data to the minimum possible, allows the
creation of an object called VIEW.
Define:= A VIEW is mapped , to a select sentence. The SELECT
clause consists of a sub-set of the columnb of the table.
thus a view , which is mapped to a table, will in effect
have a sub-set of the actual column of the table from which
it is bulit.

This technique offers a simple, effective way of hiding
column of the table.

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

Which components manage deadlocks in db2?

0 Answers  

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---

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

0 Answers  

---

Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,

---

What is DCLGEN ?

3 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

What is COPY PENDING status?

6 Answers  

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---