Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
View - what is the Advantage?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
hisabari

New User


Joined: 10 May 2005
Posts: 3

PostPosted: Tue May 10, 2005 1:18 pm    Post subject: View - what is the Advantage?
Reply with quote

What is the difference while u are Inserting in to a table as well as
inserting into view to update the table. Ie., thru this view to update the
same table.

Eg. Emp is a table with eno,ename,esal
VEmp is the View , having the same structure and size of the Emp.
Table.

Now I am inserting first rec. to Emp table. And the another record is inserting in to the view. Okay what is the advantage while u are inserting this second record thru view to Table.

Pls. give me the advantages of View.
Back to top
View user's profile Send private message

i413678
Currently Banned

Active User


Joined: 19 Feb 2005
Posts: 112
Location: chennai

PostPosted: Tue May 10, 2005 1:41 pm    Post subject: Re: View - what is the Advantage?
Reply with quote

Hi

Advantages of Views are:

1. it provides the data security.
2. the same table can be appeared as different for different users.
3. provides DOMAIN INTEGRITY with WITH CHECK OPTION.
4. provides to derive new attributes by using aggregate functions.



Cheers.................

pavankumar
Back to top
View user's profile Send private message
hisabari

New User


Joined: 10 May 2005
Posts: 3

PostPosted: Tue May 10, 2005 7:41 pm    Post subject:
Reply with quote

Hi Pavan,

Thankx for ur nice Answer. But if u have a table with , u create a View with same column .(Ref the above Eg.) Now u are updating view. It will be updated in the Table also right??? then What is the Security. I am till confusion abt view in this case.

Can u explain me. And Pls Ans. my Above example also.

Cheers

sabari
Back to top
View user's profile Send private message
vasanthanc

New User


Joined: 01 Apr 2005
Posts: 58

PostPosted: Wed May 11, 2005 11:44 am    Post subject:
Reply with quote

Pavan has clearly explained the advantages of views. There is no need to create a view with all the fields and rows of a table and with no additional (for ex: aggrate function) columns. And in case, if you have such a view, then there is no difference, if you update a table directly or through the view
Back to top
View user's profile Send private message
hisabari

New User


Joined: 10 May 2005
Posts: 3

PostPosted: Wed May 11, 2005 6:48 pm    Post subject:
Reply with quote

Thanx vasanth and Pavan,

I got some better idea about view in this case.


Cheers
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts REXX to view the PGM or PROC jackzhang75 CLIST & REXX 11 Tue Jun 20, 2017 1:20 am
No new posts How to see VIEW definition from BMC c... rohanthengal DB2 1 Thu May 04, 2017 1:50 pm
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts how to find clist's or view library Andrew Hsia CLIST & REXX 4 Tue Jun 28, 2016 6:07 pm
No new posts Report view in Mobile devices Robert Sample All Other Mainframe Topics 0 Thu Jun 23, 2016 7:05 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us