IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Difference between alias and view
IBM Mainframe Forums -> HomeWorks & Requests
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
surya.kalyan

New User


Joined: 09 Jan 2007
Posts: 20
Location: Mumbai
PostPosted: Mon Jun 25, 2007 5:18 pm
 Reply with quote
Hi,
I wanted to know the difference between an alias and view in DB2 for Z/OS.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
PostPosted: Mon Jun 25, 2007 7:07 pm
 Reply with quote
Hello,

A view is a way to look at data.

An alias is another name for some entity.
Back to top
View user's profile Send private message
Umamaheswari K

New User


Joined: 23 May 2007
Posts: 2
Location: chennai
PostPosted: Tue Jun 26, 2007 9:05 am
 Reply with quote
ya u r right dick...
View is just another definition of table in order to reduce the redundancy of data while improving data security...
but alais is just another name for a table or column...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> HomeWorks & Requests

 

Similar Topics
Topic Forum Replies
No new posts SET PATH in View DDL DB2 2
No new posts How to delete a user's alias from the... JCL & VSAM 11
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts Issues with VIEW DATASET Command CLIST & REXX 2
No new posts Timestamp difference and its average ... DB2 11
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us