Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Diff btn Join and View

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

New User


Joined: 31 Mar 2005
Posts: 16
Location: Bangalore

PostPosted: Tue Apr 12, 2005 3:39 pm    Post subject: Diff btn Join and View
Reply with quote

Dear Friends

What is the basic difference between view and a join.

Why i am asking is ..... by using views or joins we can combine columns from one or more tables and can update only if view or join are from one table only, if its more than one it cant be updated in both cases.

then what is the diff btw view and a join....

Ajay Chandra
Back to top
View user's profile Send private message

Sumathi.bonagiri

New User


Joined: 06 Jun 2005
Posts: 3
Location: Bangalore

PostPosted: Tue Jun 07, 2005 6:08 pm    Post subject: Re: Diff btn Join and View
Reply with quote

ajaychandra wrote:
Dear Friends

What is the basic difference between view and a join.

Why i am asking is ..... by using views or joins we can combine columns from one or more tables and can update only if view or join are from one table only, if its more than one it cant be updated in both cases.

then what is the diff btw view and a join....

Ajay Chandra



Hi ajay

The difference b/w join and view is view is a virtual table ,and join is an existing thing.
Access permissions can be set on views in case of joins its not so.
this much i know.
any corrections welcome.
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 Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
No new posts How can we have the varying lenth of ... Gunapala CN DFSORT/ICETOOL 6 Fri Oct 14, 2016 7:31 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
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us