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
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: 19245
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 Difference between VALIDPROC and CHEC... DB2 3
No new posts View GDG data which is copied from a ... JCL & VSAM 2
No new posts Ca view compatibility CA Products 3
No new posts Difference between CEE3250C and CEE3204S COBOL Programming 2
No new posts Difference between sysexec and sysproc CLIST & REXX 6
Search our Forums:

Back to Top