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 How to see VIEW definition from BMC c... rohanthengal DB2 1 Thu May 04, 2017 1:50 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
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


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us