What is a view? Why use it?
Answers were Sorted based on User's Feedback
Answer / aditya
view is used to create another representation of data where
we can protect the important data from public view.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / purushothr
view is a logical table that can be created by one or more
base table
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / srinivasa yadav
VIEW IS A VIRTUAL MEMEORY SPACE WHICH DOES'NT HOLD ANY DATA.
MAINLY VIEW IS USED TO RESTRICT AUTHORIZATION FOR THE
USERS. SO USER CAN ACCESS ONLY PARTICULAR COLUMNS.
| Is This Answer Correct ? | 0 Yes | 3 No |
what is the input to PLAN? what is the input to DBRM?
What is package versioning? Please give an example.
What is ACQUIRE/RELEASE in BIND?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
When is the authorization check on DB2 objects done - at BIND time or run time?
Can we install 2 different versions of Db2 on same mainframe?
what is the process of precompiler?
What is data manager?
Explain about rct.
What is multi row fetch in db2?
What is access path in db2?
Name some fields from SQLCA.