why we create view.
- 5 Answers
- 8635 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / as
I know a senario in which views are created.
Suppose I have a field in my table which is secure and
should not be visible to everyone. In that case i can
create a view without that field and keep the table acces
(even browse) with a particular set of people.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / wazid noor mohammed
sometimes u have to write complex queries.
for this query u can give one name.
For to give that name we use view concept.
after defining the view with the particular name to the
complex query.
Next time ,we can execute that query by simply calling the
view name of that query
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / om prakash yadav
Provide the Security and see the part of data.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / vinay
to ristrict the full access of table data... to users or
group of users
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / om yadav
the reasons why view are created are:
1. When data security is required.
2. When data redundancy is to be kept to the minimum while
maintaining data security.
| Is This Answer Correct ? | 5 Yes | 2 No |
what is the process of precompiler?
What is null in db2?
What is a LIKE table and how is it created?
what is diffrence b/w file-aid tool and file-aid utility???
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What will the COMMIT accomplish?
What is db2 bind process?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
where can we use index and subscript ? with example ?
What is the use of db2?
what is Static and dynamic linking
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
COBOL 
