Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
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?
Explain how can you do the explain of a dynamic sql statement?
What is commit in db2?
What is cobol db2?
What is the default page size of buffer pools?
Is ibm db2 open source?
What is bufferpool in db2?
What is db2 connect?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is a plan and package in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the information associated with sysibm.syslinks table?
Explain the contention situations caused by locks?
On which levels locks can be applied?
